
Re: Limiting a dimension
Siddharth Sheshadri Jun 9, 2017 9:00 AM (in response to Siddharth Sheshadri)I tried this:
IF(SUM(Surveys)>1,
aggr(if(rank(SUM(Surveys))<=5,[Assignment Group],'Other'),[Assignment Group]),0)
However it says invalid although there is no err in calculation.

Re: Limiting a dimension
Siddharth Sheshadri Jun 9, 2017 1:26 PM (in response to Siddharth Sheshadri)Made some advancements:
This is what I tried last:
IF(SUM(Surveys)>1,
aggr(if(rank(SUM([NPS Score])/SUM(Surveys))<=5,
[Assignment Group],'Other'),[Assignment Group]),NULL())
I am trying to find the bottom 5 however on a measure to which I have a cut off of SUM(Surveys) > 1
When I try the above, it is giving an "Invalid dimension" error.
Thanks in advance.


Re: Limiting a dimension
Pankaj Thakur Jun 10, 2017 11:14 PM (in response to Siddharth Sheshadri)Hi Sidharth,
Try if(Sum(Profit)>1000,Sum(Profit)) in definition of your chart and then use dimension limit option.
Regards,
Pankaj

Re: Limiting a dimension
Meisam Nazariani Jun 11, 2017 8:15 AM (in response to Siddharth Sheshadri)Hi
In QlikView 12 you can simply use "Dimension Limits" tab to manage displayed values.

Re: Limiting a dimension
jagan mohan rao appala Jun 12, 2017 1:31 AM (in response to Siddharth Sheshadri)Hi Siddharth,
Try like this using Set Analysis, using If() and Aggr() sometimes will have performance issues.
Sum( {$<Location = {“=Sum(Profit ) > 1000”}>} Profit )
Hope this helps you.
Regards,
Jagan.

Re: Limiting a dimension
Siddharth Sheshadri Jun 12, 2017 3:23 AM (in response to Siddharth Sheshadri)Thanks Pankaj, Meisam and Jagan but I am not only trying to limit the dimension, I have to sort them as well which is why I have to use rank.
IF(SUM(Surveys)>1,
aggr(if(rank(SUM([NPS Score])/SUM(Surveys))<=5,
[Assignment Group],'Other'),[Assignment Group]),NULL())
The above formula first limits the dimension to Surveys>1 and then ranks them with a negative number so that I get the bottom 5.
Since for my logic, the bottom 5 must not consider the groups which have less than 1 survey, I limit them.Once I use this as my sorting expression,
IF(SUM(Surveys)>1,
aggr(if(rank((SUM([NPS Score])/SUM(Surveys)))<=5,
(SUM([NPS Score])/SUM(Surveys)),99999),[Assignment Group]),NULL())
Once this is sorted, I get the bottom 5 groups which have a bad score.
However this is giving an invalid dimension error
@meisam, I am using Qlik Sense and not Qlikview.
Regards,
SS.
