Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Changing Dimension limits on drill down group

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

1 Solution

Accepted Solutions
PradeepReddy
Specialist II
Specialist II

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))

View solution in original post

4 Replies
PradeepReddy
Specialist II
Specialist II

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))

Not applicable
Author

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

PradeepReddy
Specialist II
Specialist II

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))

View solution in original post

Not applicable
Author

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