Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
For max
Max (Total Aggr (YourExpression,Datefield) )
And for min
Min (Total Aggr (YourExpression,Datefield) )
For max
Max (Total Aggr (YourExpression,Datefield) )
And for min
Min (Total Aggr (YourExpression,Datefield) )
Try expression like:
count({<DateField={'$(=Date(max(DateField)))' , '$(=Date(min(DateField)))'}>}ID)
It worked perfectly ! thanks !
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.