Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

andreyfcdk91
New Contributor III

Rank function in calculated dimension

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!

Tags (1)
1 Solution

Accepted Solutions

Re: Rank function in calculated dimension

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.


talk is cheap, supply exceeds demand
3 Replies

Re: Rank function in calculated dimension

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.


talk is cheap, supply exceeds demand

Re: Rank function in calculated dimension

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

Tick Suppress When Value is Null

Expression

SUM([Qty of Sales])

andreyfcdk91
New Contributor III

Re: Rank function in calculated dimension

Dear, thank you.

It's working

Community Browser