Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Charts which are only affected by one filter (Qlik Sense)

I am creating multiple bar charts

But i want to be able to compare these charts

I want to have 2 filter panes and 2 bar charts

1 bar chart being affected by filter 1 and chart the second chart being affected by filter 2

So that a comparison can be made

If this is possible help would be appreciated

Thank you

3 Replies
maxsheva
Creator II
Creator II

I think you are looking for alternate state in Qlik Sense.

You should have two data islands with values to use in filters.

Then try to get result using P function.

Please see solution Using Alternate State in QLikSense (without Extensions)

Digvijay_Singh

If you don't want to use alternate state, you can create two separate island tables for your filter fields( In script), with separate alias name.

In your bar chart, you can use set analysis in the measure expressions to filter records based on selections in the filter pane made out of island field names. Like below -

Sum({<facttablefield = {$(=GetFieldSelections(Islandtablefield,',',240))}>}Sales)

_armoco_
Partner - Creator II
Partner - Creator II

Hi Michael,

You need Alternate States. As already suggested you can use Island tables or use an extension. I've used an extension to achieve the same like below.

Extension link: Qlik Branch

Regards,

Arjun