
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Rank, Dense Rank, Hrank Function
Hi All,
could you please help me in understanding the logic behind Rank, Dense Rank, Hrank Function.
- Why and in which scenario we're using it ?
- what exactly the difference between these 3 functions. ?
- What will be the syntax ?
- are these Script function or chart function ?
- Example: I've have below table, i need to apply these function Rank, Dense Rank, Hrank Function. How to do that in chart and script both ?
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.
- Tags:
- qliksense


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
