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

    Qlik Sense Server - count multiple conditions

    Richard Judkins



      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.