Using Gauge Chart to display data for Max(Date)

[#1]

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))

[SergeyMak]

Hi

I don't know Maximum() function

I know only Max()

[#3]

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.

[SergeyMak]

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