topic Re: How to make a separate filter for each chart? in QlikView

How to make a separate filter for each chart?

Dmitryromanov23 — Mon, 01 May 2023 19:19:34 GMT

I have 2 identical stacked bar charts in qlikview. I need to select 2 date ranges in the filters. How can I make one chart display data related to the first date range and the second chart display data for the second date range?

I tried to do it with the set analysis by {$1} but it is inconvenient. Can you please tell me how to do it in another way?

Re: How to make a separate filter for each chart?

Lisa_P — Mon, 01 May 2023 23:35:19 GMT

Alternate states is the solution. Create a new alternate state eg State1 and apply it to the first filter and the first chart. Create another alternate state eg State2 and apply it to the other filter and chart.

Re: How to make a separate filter for each chart?

Prem0212 — Tue, 02 May 2023 06:30:57 GMT

we can achieve this Alternate states option.

First create two Alternate States dimensions and assign the those dimensions to the two separate filters and charts that should be used.

It will work.

Please like and accept the solution if u like the answer.