4 Replies Latest reply: Jun 9, 2017 6:56 AM by Siddharth Sheshadri RSS

    Dimension is breaking/faulty

    Siddharth Sheshadri

      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