11 Replies Latest reply: Oct 2, 2017 5:33 AM by Joanna Seldon RSS

    Count if / only qlik sense

    Joanna Seldon

      Hi

       

      trying both ways , but wrong ..can I have some help please

       

      I want to only ever count customers that only order on a specific month, and not on any other month of the year

       

      e.g August

       

      I have tried this way but don't work

       

      Count(DISTINCT if([Month]='Aug', CustomerID))

       

      I have heard you can do this with an only command

       

      only({<[Month]={'Aug'}>} CustomerID)

       

      but how do you count using an only?

       

      please help