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

    Count Objects for Max Date in Set Analysis

    Arianna Nelli


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


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


      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,