Summer Special Limited Time 60% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 8w52ceb345

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

Qlik QSDA2021 Full Course Access
Qlik QSDA2021 View All Questions

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.

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

B.

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

C.

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

D.

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

QSDA2021 PDF/Engine
  • Printable Format
  • Value of Money
  • 100% Pass Assurance
  • Verified Answers
  • Researched by Industry Experts
  • Based on Real Exams Scenarios
  • 100% Real Questions
buy now QSDA2021 pdf
Get 60% Discount on All Products, Use Coupon: "8w52ceb345"
Next
Refer to the exhibit.
A data architect needs to build an Order Fulfillment app.
Previous