Dimension is breaking/faulty

[Anonymous]

Hi all,

I have a dimension with the following formula:

aggr(if(rank(SUM(Measure))<=5,[Dimension],'Other'),[Dimension])

The dimension is supposed to show the top 5 and then an "Other"

However, this dimension breaks due to some reason after I click on Other multiple times.

Thoughts on it's behavior?

Please see the below image where it is showing more than 5 fields before the "Other"

[rittermd]

Instead of all of that why don't you just use the Limitation capability built into Qlik Sense for the Dimension?

Set it to Fixed Number and then choose Top 5 with a check box to show Others or not.

[sunny_talwar · Accepted solution]

How about this

Aggr(If(Rank(Sum({1} Measure)) <= 5,[Dimension],'Other'),[Dimension])

[Anonymous]

Hey Mark,

The limitation capability does not work well for a stacked bar chart. That is what I am planning to do with this although the image does not show it.

[Anonymous]

Hey Sunny, if I do that and click on "Other" then it does not drill me down into the remaining dimensions like the way how it works when the "Other" functions if limited using Qlik's default limitation capability!

I do know the answer to my problem though. After a certain drill downs, the measure has same values across multiple rows, so the ranking is maintained and is hence not limited.

I guess I will have to live with this functionality.