4 Replies Latest reply: Apr 13, 2017 10:44 AM by xavier hemelaar RSS

    Count(ID) only if date is max/min count(ID)

    xavier hemelaar

      Hi Qlikers,

       

      in the chart bellow we have "date" as dimenssion and count(ID) as measure.

      In a simple KPI I would like to find the max and min value.  So this will be 13/04/2017  and 11/04/2017 in this case. What is the expression to get those values?

       

      Thanks for your support