Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

beck110979
Valued Contributor III

Top 5

Hi Folks,

i got a question: my situation does look like: one dimension and 1 expression

i am using: calculated dimension to show top 5:

=if(aggr(rank(sum(Preis)),Artikelnummer) <= 5, Artikelnummer, Null())

and my expression does look like:

Sum(Preis)

i want to show only Top 5, but i have a deviation and my table shows me the Top 7 (please see the attached screenshot)

my question: how can i force to show only Top 5 ?

Thanks a lot

Beck

5 Replies
OmarBenSalem
Esteemed Contributor

Re: Top 5

In ur dimension, limit it to the top 5 Beck; no need to use rank.

(and ps: it's because u have 3 dimensions that have the same value)

beck110979
Valued Contributor III

Re: Top 5

Hi Omar,

thanks a lot for your feedback and help.

I know, i can limit my dimension via setting within table (for instanse: limit to 5). i wanted to know how to solve this issue with help of calculated dimension.

Thanks a lot

Beck

Re: Top 5

3 Articles have the same exact Preis... which one of the three would you want to show in the top 5?

Capture.PNG

thiago_justen
Valued Contributor III

Re: Top 5

What about this:

=if(aggr(rank(sum(Preis),3),Artikelnummer) <= 5, Artikelnummer, Null())

Thiago Justen Teixeira Gonçalves
WhatsApp: 24 98152-1675
Skype: justen.thiago
beck110979
Valued Contributor III

Re: Top 5

Hi Thiago,

thanks a lot for your help and feedback

Community Browser