How to find Top customers in QlikView

[Anonymous]

I tried using Rank Function to find the top customers. but people say it is not the right way to find top customers.

Can anyone help me to find the top customer through Scripting in QlikView?

Thank you!

[krishnacbe]

Hi,

You can use Dimension Limit to find the Largest or Smallest Values.

Pivot Tables does not have the Dimension Limit you need to use the Rank with Aggr function.

[Siva_Sankar]

Kiran,

It depends on many factors. Say for example, if you want to rank by more than one dimension you cant use dimension limits. However, you can check the possible ways to implement Top n analysis here in qlikview i want take top 10 salaries how to wright ?

Siva

[Anonymous]

That was helpful. Thanks for the link1

[Siva_Sankar]

Great that it was helpful for you. Mark it as correct answer and close the thread if you got what you wanted.

Siva