Exam QSDA2024 topic 1 question 13 discussion

Actual exam question from QlikView's QSDA2024

Question #: 13
Topic #: 1

[All QSDA2024 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. Concat(DISTINCT IF(Aggr(Rank(Sum(Sales),4),SalesPerson)=1,SalesPerson),' ')
B. FirstSortedValue(DISTINCT SalesPerson,-Aggr(Sum(Sales),SalesPerson))
C. FirstSortedValue(SalesPerson,-Aggr(Sum(Sales),SalesPerson))
D. Concat(DISTINCT IF(Aggr(Rank(Sum(Sales),1),SalesPerson)=1,SalesPerson),' ')

Show Suggested Answer

Suggested Answer: D 🗳️

by Jdossa91 at Jan. 20, 2025, 10:57 a.m.

Comments

Submit Cancel

Jdossa91

2 weeks, 2 days ago

Selected Answer: A

Goal: The measure must return all salespeople with the highest sales. When two or more salespeople have the same top sales amount, all of them must appear. Key Components of the Expression: Aggr() Function: Creates a temporary table that calculates the sum of sales grouped by SalesPerson. Rank(Sum(Sales),4) is used because the 4 parameter ensures that all tied values at rank 1 are considered (dense ranking). IF() Function: Filters only the salespeople who are ranked as 1 based on their sales. Concat() Function: Concatenates all salespeople who meet the condition (rank = 1) into a single string, separated by a space.

upvoted 1 times

...

Exam QSDA2024 All Questions

View all questions & answers for the QSDA2024 exam

Exam QSDA2024 topic 1 question 13 discussion

Comments

Jdossa91

SY0-701