Exit QSDA2019 Qlik Sense Data Architect Certification - June 2019 Release
Question 2 of 5
0% complete
Q2 Single choice

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

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

  • B

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

  • C

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

  • D

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

Previous Next