1 Reply Latest reply: Feb 26, 2018 3:32 PM by Hari Nag RSS

    Two formulas comparison

    Wanyun Yang

      Hi guys,

       

      I'm new to Qlik Sense. What is the difference between:

      COUNT(IF(value=20,value))

      and

      COUNT({<value={"20"}>}value))?


      Thanks for help!

        • Re: Two formulas comparison
          Hari Nag

          COUNT(IF(value=20,value))


          In this it wont create a subset where value = 20 so in the above expression it will count null values.


          COUNT({<value={"20"}>}value))

          It will create a exact subset and it will count where that condition satisfies.


          Hope this helps