13 Replies Latest reply: Jul 24, 2018 12:29 PM by Sunny Talwar RSS

    Counts in pivots-QlikView

    Igor Gershenson

      I have a table like this. when I pivot it, I only want to do a distinct count of Names with Status MQL, I want the count to ignore the names associated with the not MQL status. Here is the expression I thought would work:

      if(FINALMQLSTATUS='MQL',Count (DISTINCT [Name]),0)      

         

      NameFINALMQLSTATUS
      BobMQL
      JimNot MQL
      SallyMQL

       

      However, it still counts all of them and seems to ignore the if statement. Please help. What am I doing wrong? Thank you