topic Avoiding alternate states in QlikView

Avoiding alternate states

gautik92 — Wed, 25 Nov 2020 16:16:04 GMT

I have two charts the one is line chart with monthyear as dimension

and other is a bar chart with products as a dimension

and I want to have a year and month filter only for 2 chart and not for the line chart which is having monthyear as dimension

I am using alternate states but is there any other way to do this?

tresB — Mon, 25 Sep 2017 10:26:20 GMT

Have you tried using Set Analysis? You could try like: Sum({<Year>} Sales) to avoid Year dimension selection.

Anil_Babu_Samineni — Mon, 25 Sep 2017 10:31:28 GMT

I believe this is the good option unless with in set analysis you can write identifier of Alternate states..

gautik92 — Mon, 25 Sep 2017 10:55:25 GMT

can I do this without using alternate states

Anil_Babu_Samineni — Mon, 25 Sep 2017 10:57:38 GMT

If you look Treesesco answer it may helps you. You need to degrade the fields from Bar chart of 2 fields if you don't want to change from selection..

gautik92 — Mon, 25 Sep 2017 10:59:29 GMT

in the first chart am using monthyear as dimension ignoring selections is not working