Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

siddharth_s2
New Contributor III

Dimension is breaking/faulty

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"

Qlik.PNG

Tags (1)
1 Solution

Accepted Solutions

Re: Dimension is breaking/faulty

How about this

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

4 Replies
rittermd
Honored Contributor

Re: Dimension is breaking/faulty

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.

Re: Dimension is breaking/faulty

How about this

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

siddharth_s2
New Contributor III

Re: Dimension is breaking/faulty

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.

siddharth_s2
New Contributor III

Re: Dimension is breaking/faulty

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.

Community Browser