topic Changing Dimension limits on drill down group in QlikView

Changing Dimension limits on drill down group

Fri, 22 Jan 2016 17:12:29 GMT

Hi all,

I have a Drill Down group, and on it I have the Dimension Limits set to only show me the top 10 in my barchart.

Is there a way that the Dimension Limit can be disabled when I click and drill down to the next level? So on the bar chart the first thing I want to see is the Top 10, but when I click into one of the items I do not want the next drill down item to be limited to 10 values.

Any way of doing this?

Thanks

Re: Changing Dimension limits on drill down group

PradeepReddy — Fri, 22 Jan 2016 17:39:03 GMT

try like this..

First create a drill down group 'Drill_Grp1' with the hierarchy Country-->State. and then..

In dimension limits place the bellow expression and uncheck the 'show other options'

=if(GetCurrentField(Drill_Grp1)='Country',2,GetPossibleCount(State))

Re: Changing Dimension limits on drill down group

Mon, 25 Jan 2016 11:23:23 GMT

Hi,

Sorry I am not sure I follow/can't get it to work. I have made a file with some dummy data based on your example, can you show me what you mean?

Its just Dummy data so United States is the only country you can drilldown to that shows the states. But in this example I want it to show me the Top 10 countries by Population, as it's doing now, but when I click into United States I want it to show me the population of all states not just top 10.

In my actual project I am working on my drilldown group is more than 2 fields if that matters -- but same principle, I only want the Top 10 on the initial chart, not any of the latter drilldowns.

Thanks for your help

Re: Changing Dimension limits on drill down group

PradeepReddy — Mon, 25 Jan 2016 11:31:51 GMT

see the attachment...

Delete the second expression

=if(GetCurrentField(Drill_Grp1)='Country',10,GetPossibleCount(State))

In dimension limits tab, instead of 10, write the bellow expression

=if(GetCurrentField(Drill_Grp1)='Country',10,GetPossibleCount(State))

Re: Changing Dimension limits on drill down group

Mon, 25 Jan 2016 11:49:44 GMT

wow, very cool, didn't know you could put an expression in that box. Makes sense now, thanks!