Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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

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

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.

Anonymous
Not applicable
Author

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

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.

Anonymous
Not applicable
Author

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
Specialist III
Specialist III

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

Anonymous
Not applicable
Author

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