Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am developing a Qlik dashboard and I am looking for how to apply filter1 to graph1 and apply filter2 to graph2 (without filter 1 being applied).
Can you help me to do it.
Are you looking to hard-code the filters on each graph, in which case you require set analysis in the chart expressions, like this:
sum({<ChartType*={'Filter1'}>}Value)
and
sum({<ChartType*={'Filter2'}>}Value)
Or if you want the user to be able to select the filters in each chart you need to use Alternate States.
Go to Master Items and Alternate States and then select Create New:
Call the state Filter2 and select Create.
Once you have done this there will be an extra option on the properties of every object, called Alternate States where you can select to put that object either in the default state or the Filter2 state:
Note that to have filter options you need to have a Filter Pane that is put into each state also.
The <inherited> option is where you can put an entire sheet into a different state, and all objects on that sheet will be in that state.
If you want your app to be as bad as a PowerBI app you can create a new state for each sheet and no selections will carry through from one sheet to another.
Hope that helps.
Steve
Are you looking to hard-code the filters on each graph, in which case you require set analysis in the chart expressions, like this:
sum({<ChartType*={'Filter1'}>}Value)
and
sum({<ChartType*={'Filter2'}>}Value)
Or if you want the user to be able to select the filters in each chart you need to use Alternate States.
Go to Master Items and Alternate States and then select Create New:
Call the state Filter2 and select Create.
Once you have done this there will be an extra option on the properties of every object, called Alternate States where you can select to put that object either in the default state or the Filter2 state:
Note that to have filter options you need to have a Filter Pane that is put into each state also.
The <inherited> option is where you can put an entire sheet into a different state, and all objects on that sheet will be in that state.
If you want your app to be as bad as a PowerBI app you can create a new state for each sheet and no selections will carry through from one sheet to another.
Hope that helps.
Steve