3 Replies Latest reply: Jun 10, 2016 7:12 AM by Nhu Ngo RSS

    How to syntax logical condition that ALL filters are selected

    Pieter Krsteff-Jantcheff

      I have a filter pane with three filters: 'Belgium', 'Netherlands' and 'Luxembourg'.

       

      Based on whether one, two or all of these countries are selected a different formula has to be applied to get a score. My syntax so far looks like this:

       

      if(CountryName='Belgium', 5+3,

       

      if(CountryName='Netherlands', 6+2,

       

      if(Countryname='ALL', 9+1)))

       

      Of course these formulas are not the real ones, but I use these for simplicity. The mistake is in the last line. How do I tell Qlik to apply the formula '9+1' when ALL filters are selected?

       

      Many thanks for an answer!