Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Not applicable

Help On Rank Function

Hi All,

can any one help me regarding the following issue please:

I have a report containing the Loan and outstanding data. Below is an example


I have to show the top 3 Customers for Loan or for Outstanding. I tried with a pivot table in qv by applying the Rank() Function.

When I tried with the following details

Dimention - Customer name

Expression- Loan, Outstanding, =Rank(Loan), the Rank function is working fine. But When I am putting all fields as Dimention(Country, Name, ID, Group and Industry) the Rank function is not working and only showing 1 all entry. (I need to show all the fields in the table)

Can you please help me, where I am going wrong.

Attached is the sample for reference.

Tags (2)