Discussion Board for collaboration related to QlikView App Development.
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.
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.
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.
Excellent! Flawless.
Is it possible to do the same on Qlik Sense?
not working for me