Qlik Sense Drill down

[MeeraAgrawal]

Hi Guys,

I have two sheet sheet1(Country wise) and Sheet2(State wise) I want to apply filter from country sheet to state sheet. when I will select any country then it will bring me sheet 2 by applied filter in sheet one.

Ex. If I will select India from sheet 1 then related state shown in sheet 2.please find attached screen shot

I am working on Qlik sense cloud.

[fosuzuki]

I'm afraid it is not possible to change the sheet only based on a filter.

As an alternative, you can add a button to the first sheet, with an action to change to the second sheet.

[MeeraAgrawal]

Hi @fosuzuki 

How can I add multiple button . Number of country are 215 in my data?

[fosuzuki]

Wait, multiple button as you want to add 215 buttons?

As I see it, you only need one button. The second sheet is generic, will show the data for the selected country right?

The April2020 version has a native Button object you can use, and then set an Action to change the sheet.

[MeeraAgrawal]

I have bar chart with axis country I want to see data related to particular country to another sheet. is there no way in Qlik sense to filter data based on selection in previous sheet?

[jonathandienst]

Qlik selections apply to all sheets, so if you make a selection in sheet 1 and then move to sheet 2, the selections made in sheet 1 will still apply.

[MeeraAgrawal]

I understand your point and yes it's workable as you mentioned but client don't want to click that button he wants to move from one chart to another sheet. if you see in PBI make it possible by using right click drilldown feature. Same workaround I want in Qlik sense.

[MeeraAgrawal]

Hi @jonathandienst 

I tried with your way as well. but it's not working .

I have country filter in sheet1 and state filter in sheet2 I have applies India from sheet1 then jump to sheet 2 then it show first state of India only rather then all of the states.

If you will say need to ad country filter in sheet2 then I don't want to show this to user. I have attached some screen shots for your reference.