Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Ranjanac
Contributor III
Contributor III

Rank, Dense Rank, Hrank Function

Hi All,

could you please help me in understanding the logic behind Rank, Dense Rank, Hrank Function.

  1. Why and in which scenario we're using it ?
  2. what exactly the difference between these 3 functions. ?
  3. What will be the syntax ?
  4. are these Script function or chart function ?
  5. 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. 

1 Reply
Or
MVP
MVP

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.