Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
joantbak
New Contributor III

Drill down Group and Limits

Is it possible to have Dimension Limit or Presentation - Max number only show X rows/results at the top drill level and then have no limits as drilled?

So I have For example I have Drill down with 3 levels, 1, 2 & 3 at level 1 (ie no drill) I only want to see the top 3 largest results based on the expression (there is just 1 sum expression resulting in a money amount).  When I drill down to level 2 and 3 I want no limits on results but just the data related to the item selected at level 1.

If the above is not possible I would settle for having no limits but when I drill down to level 2 just see the results relating to the item selected at level 1 (currently I get all level 2 results relating to all level 1 items)

Sure there is a simple solution I'm missing....

5 Replies

Re: Drill down Group and Limits

I think this might be possible using multiple dimensions (or multiple drill down dimensions)

joantbak
New Contributor III

Re: Drill down Group and Limits

hmmm....

...Like using conditional show so when first Dim is selected it hides and shows a second without the limits?

Re: Drill down Group and Limits

Ya something along those lines....

tulasiram_bitra
New Contributor III

Re: Drill down Group and Limits

Hello,

Please check below it may give solution.

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

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

balabhaskarqlik
Honored Contributor

Re: Drill down Group and Limits

Did you resolved the issue, post the solution.