topic Re: Rank function in calculated dimension in QlikView

Rank function in calculated dimension

Anonymous — Fri, 13 Jun 2014 15:20:13 GMT

Good Day!

I'm making pivot table with dimesions and expressions described on the picture.

How can i use rank function in calculated dimension to select best 5 points of sales?

Many thanks for help!

Gysbert_Wassenaar — Fri, 13 Jun 2014 15:29:59 GMT

Something like this: =aggr(if(rank(sum(Sales))<=5,[Sales Point]),[Sales Point])

Change Sales and Sales Point to reflect your real dimension names.

But try to use Dimension Limits instead. Those are less costly than calculated dimensions.

MK_QSL — Fri, 13 Jun 2014 15:31:15 GMT

IF(Aggr(Rank(SUM([Qty of Sales]),4),[Sales Point]<=5,[Sales Point])

Tick Suppress When Value is Null

Expression

SUM([Qty of Sales])

Anonymous — Mon, 16 Jun 2014 13:03:54 GMT

Dear, thank you.

It's working