A data architect needs to write the expression for a measure on a KPI to...

Vendor: Qlik
Product: QSDA2022
Update on: Aug 1, 2025
Questions: 77

Qlik QSDA2022 Question Answer

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?

FirstSortedValue (Salesperson, -Aggr (Sum(Sales) , Salesperson) )

Concat(DISTINCT IF (Aggr (Rank (Sum (Sales) , 4) , Salesperson) =1, Salesperson) , ' ')

FirstSortedValue (DISTINCT Salesperson, -Aggr (Sum(Sales) , Salesperson) )

Concat (DISTINCT IF (Aggr (Rank (Sum (Sales) , 1) , Salesperson) =1, Salesperson) , ' ')