topic Re: set analysis with different alternate states in QlikView

set analysis with different alternate states

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

Hi all,

I have a chart which should have an exclusive filter for it. i.e. this filter when selected should affect only this chart.

But this chart should be responsive to other filters as well.

for e.g in one sheet I have chart A and Chart B

Filters are filter 1, filter2, filter 3.

Filter 3 should be only for chart B. when any selection is made in filter 3 it should be reflected only in chart B.

But when any selections made in filter 1 or 2 should also reflect in chart B.

Kindly let me know if this can be achieved by alternate states

Thanks,

Anupama Jagan

swuehl — Wed, 07 Mar 2018 09:48:17 GMT

Yes, it should be possible to achieve this using alternate states:

1) Create an alternate state AS

2) Set the listbox for filter 3 to state AS

3) Leave the chart B inherited from default state

4) In the chart aggregations, use set analysis to bring in the selection from the alternate state list box:

=Sum({$*AS} Value)

=Sum({$<[Filter 3] = AS::[Filter 3]>} Value)

Anonymous — Wed, 07 Mar 2018 10:26:45 GMT

Thanks a lot Stefan!