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

    Count if / only qlik sense

    Joanna Seldon



      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