11 Replies Latest reply: Jan 11, 2018 6:34 AM by Arianna Nelli RSS

    Count Objects for Max Date in Set Analysis

    Arianna Nelli

      Hello,

      I have a table showing Category Code, Sales Date, and Objects:

      TESTA.JPG


      I want to calculate for each Category Code the quantity of distinct Objects that have the max Sales Date for each Category Code:
      TESTB.JPG

       

      In this example for the Category Code=1, I want that #Objects=2 because there are 2 distinct Objects that have the Sales Date 18/12/2017.

      I'm using the Version November 2017 of Qlik Sense.

       

      Any suggestion?

      thx a lot,

      Arianna