Free Preparation Discussions
MENU
Qlik Exam QSDA2024 Topic 4 Question 3 Discussion
Topic #: 4
A data architect needs to write the expression for a measure on a KPI to show the sales person with the highest sales. The sort order of the values of the fields is unknown. When two or more sales people have sold the same amount, the expression should return all of those sales people.
Which expression should the data architect use?
A)
B)
C)
D)
The requirement is to create a measure that identifies the salesperson with the highest sales. If multiple salespeople have the same highest sales amount, the measure should return all of those salespeople.
Explanation of Option A:
Rank(Sum(Sales), 1): The Rank() function is used to rank salespersons based on the sum of their sales. The rank 1 indicates the top position.
Aggr() Function: This function aggregates the data and returns the results grouped by the SalesPerson field.
IF() Condition: The IF condition checks if the salesperson's rank is 1 (highest sales).
Concat(DISTINCT ...): The Concat() function concatenates all the salespersons who have the highest sales, separated by spaces or another delimiter, ensuring that all top performers are returned.
Example:
If three salespersons have the highest sales, this expression will return all three names separated by a space.
Tracey
9 months agoTammi
9 months agoGwen
8 months agoMelda
8 months agoTamie
9 months agoBelen
10 months agoLuz
10 months agoViola
8 months agoElenore
8 months agoBarney
9 months agoHannah
10 months agoLaquita
9 months agoVeronika
9 months agoMadonna
9 months agoReyes
10 months agoLaquita
10 months agoLorenza
10 months agoKristeen
10 months agoElden
10 months agoBelen
10 months agoLaquita
10 months agoBelen
11 months ago