topic Re: Alternate States - Apply Filter from one to the Other in QlikView

Alternate States - Apply Filter from one to the Other

Fri, 15 May 2015 18:46:51 GMT

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.

Re: Alternate States - Apply Filter from one to the Other

nagaiank — Fri, 15 May 2015 19:10:05 GMT

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.

Re: Alternate States - Apply Filter from one to the Other

Fri, 15 May 2015 19:37:58 GMT

Excellent! Flawless.

Re: Alternate States - Apply Filter from one to the Other

Ivy — Thu, 06 Feb 2020 22:16:34 GMT

Is it possible to do the same on Qlik Sense?

Re: Alternate States - Apply Filter from one to the Other

pranavthescholar — Wed, 10 Jun 2020 18:53:34 GMT

not working for me