2 Replies Latest reply: Oct 22, 2012 6:44 AM by Florian Pennetzdorfer RSS

    Strange issue with Select in Field

    Florian Pennetzdorfer

      Hey,

       

      Currently I'm struggling with the following issue:  My data model consists of two tables which aren't linked to each other (data islands). Via Field Event Triggers I pass selections from one field to another (Document Settings > Triggers > Field Event Triggers)

       

      test.jpg

       

      Search string:

        ='(' & GetFieldSelections(A.Region , '|') & ')'  

       

      There's just one problem when regarding "Select Excluded".  I select "Austria" and invert the Selection --> so the Current Selections Box shows "NOT Austria". I would expect to have the same selection in Field B.Region - but the selection is only applied for values that exist in A.Region....

       

      Please find the attached QVW file.

       

      Is Qlikview meant to behave like that?

       

      Regards,

      Florian