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.