How to express values from a filter with other filter

[Flipflop]

Hi,

I have two filters on the same field [Name-Archive] but with two different alternate state.

So I have the filter [Name-Archive] defines with the alternate state 'ARCHIVE 1' and the filter [Name-Archive] defines with the alternate state 'ARCHIVE 2'.

How can i create a dependence between these two filters ? When i chose a value in the first filter, i want the excluded values in the other filter and vice versa.

How can i do that ?

Thanks

[anat · Accepted solution]

=Aggr(Only({<InvID=E(s1::InvID)>} InvID), InvID)

here i have created 2 alternate states (s1 and s2)

use above logic in calculated dim

[anat]

below link will provide more info 

https://community.qlik.com/t5/QlikView-App-Dev/Copy-Selections-from-one-field-to-another/td-p/614488

[anat]

attached qvw file for your reference...

[Flipflop]

It's working, thanks a lot !