Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

paisleymike
New Contributor III

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
Contributor II

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

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
Honored Contributor III

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

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_
Contributor II

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

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

Community Browser