Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
could you please help me in understanding the logic behind Rank, Dense Rank, Hrank Function.
Customer ID |
Customer Name |
Location |
SalesPerson Name |
SalesPerson City |
Revenue |
Profit |
101 |
Elon |
America |
Elon |
Newyork |
10000 |
500 |
102 |
Mukesh |
India |
Sundar |
Newyork |
40000 |
200 |
103 |
Jeff |
America |
Mukesh |
Mumbai |
70000 |
300 |
104 |
Sundar |
America |
Narendar |
Delhi |
80000 |
700 |
105 |
Jack |
China |
Vijay |
Hyderabad |
500000 |
900 |
106 |
Steve |
America |
Amit |
Kolkata |
20000 |
600 |
106 |
Tim |
America |
Jayanth |
Bhuvaneshwar |
100000 |
500 |
107 |
Larry |
America |
Tony |
London |
350000 |
300 |
108 |
Indira |
India |
Peter |
Dubai |
150000 |
900 |
Please help me in getting the answers.
This is covered by the documentation for each individual function, as well as this: https://help.qlik.com/en-US/qlikview/May2023/Subsystems/Client/Content/QV_QlikView/Examples%20of%20C...
If you have specific questions that aren't answered by the documentation, feel free to elaborate on those.