Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Alternate States - Apply Filter from one to the Other

Hi

I'm finally to that point where I must use alternate states for something.   Basically I have an application that is doing a fair amount of comparison with independent filtering.  Unfortunately there is one attribute that when filtered, I want to apply to both sets of data.    Of course you could filter by clicking on a chart or in the multi-box, or in a search window on either state's objects.....    so I need this to work across the board and be reflective (state A to state B and state B to state A).

I'm not finding a trigger that I can apply when a new value is selected for an attribute set the filter on a different alternate state.   Does such a thing exist?  What about a work around.

I know I could do some extensive set analysis but it would be pretty messy.   I'm hoping for something a bit more manageable.

1 Solution

Accepted Solutions
nagaiank
Specialist III
Specialist III

If you have a field called 'A', create two list boxes, one for default state and the other for alternate state 'State1'

Go to Setting --> Document properties --> Triggers.

In the Filed Event triggers for Field 'A', add the following action for 'OnSelect'

Action: Select in Filed

Field: A

Search String: ='('&GetFieldSelections(A,'|')&')'

Also select 'State1' in the 'Alternate State' dropdown.

After doing this, if you select values in default state list box for A, the same values will be selected in the list box for alternate state State1.

Hope this helps.

View solution in original post

4 Replies
nagaiank
Specialist III
Specialist III

If you have a field called 'A', create two list boxes, one for default state and the other for alternate state 'State1'

Go to Setting --> Document properties --> Triggers.

In the Filed Event triggers for Field 'A', add the following action for 'OnSelect'

Action: Select in Filed

Field: A

Search String: ='('&GetFieldSelections(A,'|')&')'

Also select 'State1' in the 'Alternate State' dropdown.

After doing this, if you select values in default state list box for A, the same values will be selected in the list box for alternate state State1.

Hope this helps.

Not applicable
Author

Excellent!  Flawless.

Ivy
Partner - Contributor
Partner - Contributor

Is it possible to do the same on Qlik Sense?

pranavthescholar
Contributor
Contributor

not working for me