13 Replies Latest reply: Apr 2, 2016 10:59 AM by Sangram Reddy RSS

    How to use count distinct from one period to another?

      Dear Qlik Sense experts,


      I am new to Qlik and have been struggling to get this expression to work properly in a table.


      Columns; Order Year, Unique Items (Count(Distinct Item_Number)) and Unique Items from Year to Year


      The column creating difficulties is the Unique Items from Year to Year and the expression I have been trying is in the line with;

      • COUNT({$<Item_Number = {"Before(Item_Number)"}>} Distinct Item_Number)


      However, it returns "0" per year


      Any ideas?