Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
anupamajagan
Creator
Creator

set analysis with different alternate states

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

1 Solution

Accepted Solutions
swuehl
MVP
MVP

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)

or

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

View solution in original post

2 Replies
swuehl
MVP
MVP

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)

or

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

anupamajagan
Creator
Creator
Author

Thanks a lot Stefan!