Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am using a gauge chart which displays average of values when no filter is selected. I want to show the value for the max(date) but using set analysis it is not working. I am using the expression below:
=Maximum({1<DATE={1(=MAX(DATE))}>} $(vCalculated))
Hi
I don't know Maximum() function
I know only Max()
Sergey,
The Maximum came from the Set Analysis wizard page as I had built this for the post outside Qlik on the wizard. I did intend to use Max.
The problem however still remains the same. I need to be able to show the Metric calculation for the Max date only but currently the Gauge Chart shows an average.
I don't know what is hidden in $(vCalculated), but if it's field, but expression should be something like:
=Sum({1<DATE={$(='"' & Date(Max(DATE)) & '"')}>}$(vCalculated))
It could be simpler if your share your app or example
PFA