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

    How to syntax logical condition that ALL filters are selected

      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!