Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
gabriel_kirst
Contributor III

DrillDown Group in diferent Alternate States

Hello!

I have 4 sheets on my document, each one with a different Alternate State (the first sheet gets the default state, and each one of the others got a different state).

I've created a Drill-down Group and I need to use it in chart on different alternate states, but It just works on the sheet with the default state.

How could I do to have this Drill-Down Group working on the other States?

Regards,

Gabriel

1 Solution

Accepted Solutions
morganaaron
Valued Contributor

Re: Re: Re: DrillDown Group in diferent Alternate States

Then I think you're out of luck - there's no option to set an alternate state on a Drill Down group, so I'm afraid it wouldn't work.

The only other option is to add the fields contained within the drilldown into your dimensions on the second chart and use a GetSelectedCount() statement on both to sort of replicate the behaviour.

See attached for the example.

View solution in original post

6 Replies
morganaaron
Valued Contributor

Re: DrillDown Group in diferent Alternate States

Hi Gabriel,

You'd do this inside the analysis done on each of the other sheets.

If you have a drill down group that is Country > City, and you want the selections in the default group to run through to the other charts, where you have the other charts you'll want to use set analysis on the expressions and include:

Sum({<Country=$::Country), City=$::City)>}Sales) for example. This will keep those two fields synchronised with the drill down group (in this case country and city) selections in the default state. As long as you have the same drill down group in each of the charts as the dimension, this should mimic the same behaviour.

Highlighted
gabriel_kirst
Contributor III

Re: Re: DrillDown Group in diferent Alternate States

Hello Aaron, thanks for your answer.

I've did that, and both got synchronized. But I need they independent, each one respecting his own alternate state. Even creating 2 Drill-Down Groups, both always will respect the default state. What I need is that this Drill-Down respect other alternate state, and not the default one.

Follow attached an example document. I need both drill-downs independent from each other.

Thanks,

Gabriel

morganaaron
Valued Contributor

Re: Re: Re: DrillDown Group in diferent Alternate States

Then I think you're out of luck - there's no option to set an alternate state on a Drill Down group, so I'm afraid it wouldn't work.

The only other option is to add the fields contained within the drilldown into your dimensions on the second chart and use a GetSelectedCount() statement on both to sort of replicate the behaviour.

See attached for the example.

View solution in original post

gabriel_kirst
Contributor III

Re: Re: Re: DrillDown Group in diferent Alternate States

Thanks again, Aaron.

I've found that solution with GetSelectedCount() too, but I'd like to be sure that it can't be done with DrillDown Group. Looks like it can't be done, unfortunately.

Anyway, thanks for your help.

Gabriel

kkkumar82
Valued Contributor III

Re: DrillDown Group in diferent Alternate States

Hi Gabriel,

we are also facing a similar kind of situation, i.e. when alternate states and drill down groups are used we are unable to drill down.

Did u had any solution which works when we have both of them.

Thanks & Regards

Kiran Kumar

gabriel_kirst
Contributor III

Re: DrillDown Group in diferent Alternate States

Hello, Kiran

The only solution that I've found is the one that Aaron posted above, that uses GetSelectedCount() to simulate drilldown behaviour.

Regards,

Gabriel