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

[reivax31]

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

[vinieme12 · Accepted solution]

For max

Max (Total   Aggr (YourExpression,Datefield) )

And for min

Min (Total   Aggr (YourExpression,Datefield) )

[tresesco]

Try expression like:

count({<DateField={'$(=Date(max(DateField)))' , '$(=Date(min(DateField)))'}>}ID)

[reivax31]

It worked perfectly ! thanks !

[reivax31]

Hi, this one gave me the value of my max(date) and min(date). So in this case value from 13/04/2017 and 10/04/2017.