# New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld Online 2021, May 10-12: Our Free, Virtual, Global Event REGISTER TODAY
cancel
Showing results for
Did you mean:
Contributor III

## Rank Function

I came across this question in qlik practice test.I am confused with defining the number (mode,fmt) in rank function.4-lowest of all and number will be incremented

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

1 Solution

Accepted Solutions
MVP

@arusiva89 I think the answer should be C and that is because you want the same rank (= 1) for all the people who have the same Sum(Sales). mode 4 will give different rank to the same sum(Sales). For example, if we have A with Sum(Sales) = 100 and B with Sum(Sales) = 100, Rank(Sum(Sales), 4), will give them 1 and 2 rank, but for them to be ranked 1, you need Rank(Sum(Sales), 1)