Discussion board where members can get started with Qlik Sense.
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:
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
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)
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.
3 Articles have the same exact Preis... which one of the three would you want to show in the top 5?
What about this:
=if(aggr(rank(sum(Preis),3),Artikelnummer) <= 5, Artikelnummer, Null())
thanks a lot for your help and feedback