Halloween Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: merry71

Free Qlik Sense Data Architect Certification Exam–2022 Practice Questions

Question # 11

A data architect needs to write theexpression 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?

Options:

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) , ' ')

Discussion 0

QSDA2022 PDF

QSDA2022 PDF (Printable)
$46.5
$154.99

QSDA2022 Testing Engine

QSDA2022 PDF (Printable)
$51
$169.99

QSDA2022 PDF + Testing Engine

QSDA2022 PDF (Printable)
$63.9
$212.99

Free Exams Sample Questions