1 Reply Latest reply: Sep 18, 2017 6:10 AM by Vlastimil Kosik RSS

    Activating one filter deactivates other filter.

    Vlastimil Kosik

      I just wonder if there is an option to do the following:

       

      I have two filters:

       

      1. Profitable Companies based on 4year weighed average

      2. Profitable Companies based on 3year weighed average

       

      Obviously it does not make sense to use both at once. Thus, i am wondering if there is an option to use something like "getfieldselections" or something similar to actual deactivate one filter if the other one has been selected. (each filter works as a dummy variable, there is either a company marked as profitable based on the weighed average relevant for the type of calculation, or value is a null)

       

      thx

        • Re: Activating one filter deactivates other filter.
          Vlastimil Kosik

          bringing up my post:

           

          also, I have tried something as the following code:

           

          if(getfieldselections([Three Years History]) = 'Three Years History',

            if([Company earned weighted average operating loss] = 'Accepted', 'Profitable Companies 3Y'),

              if([Company earned weighted average operating loss 4Y] = 'Accepted', 'Profitable Companies 4Y'))

           

          This works following:

           

          Filter Three Years History not active & the above presented filter not active --> all working fine (obviously)

          Filter Three Years History active & the above presented filter not active --> all working fine

          Filter Three Years History active & the above presented filter active --> all working fine

           

          last option

          Filter Three Years History not active & the above presented filter active --> activation of this while Three Years Filter is not active starts some weird actions

           

          1. it activates automatically the filter Three Years History

          2. activates the if([Company earned weighted average operating loss 4Y] = 'Accepted', 'Profitable Companies 4Y'))

          3. gives nonsense results as it is combining the options that are basically impossible to combine

           

          3y history + average based on 4years...

           

          is this a bug or is this intended?

           

          I Mean I would expect that this would work in a following logic

           

          "If there is current selection x, use this filter, else use that filter" and that is it.. this seems that having that if(getfieldselections) in a given filter I can actually activate the other filter value which seems very weird to me.

           

          Edit: Added a qvf (simplified version where you can see the functionality of what I mean, each filter is there as typical Qlik Filter as well as "list box version" second one is an extension.