4 Replies Latest reply: Jul 17, 2017 1:06 AM by Richard Judkins RSS

    Qlik Sense Server - count multiple conditions

    Richard Judkins

      Hi

       

      So I have the following:

       

      count({<PRODUCT = {'Premier','Subscription'}>}CLIENT_ID)

       

      which does a great job of counting the client id's which have either of those products.

       

      However, I need something that counts the client id's that have both of those products, not just one or the other.

       

      I imagine it's quite simple, but I can't work it out (there isn't a lot of information online around Qlik Sense!

       

      Any help would be greatly appreciated please.