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

    How to use count distinct from one period to another?

    Lasse Liltorp

      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?