Application performance using RANK

Dayna — Wed, 21 Mar 2018 16:50:31 GMT

Hi All,

I have a rank calculation where I want to show the top 10 customers based on the sales quantity, my calculation is done as a dimension and looks like this to get the rank:

=aggr(NODISTINCT rank(sum(quantity)),customer)

From there, I then do an if statement on the customer name which looks like this:

=if((aggr(NODISTINCT rank(sum(quantity)),customer))

<= 10,

customer)

Due to the number of records in the system, this takes ages, and sometimes, does not run. What do you recommend? Have I approached this correctly?

Many thanks,

Dayna

Re: Application performance using RANK

MK_QSL — Wed, 21 Mar 2018 16:53:09 GMT

Create a Table (straight or pivot)

Dimension

Customer

Expression

SUM({<Customer = {"=Rank(SUM(quantity))<=10"}>}quantity)

topic Application performance using RANK in QlikView

Application performance using RANK

Re: Application performance using RANK