Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
LINKEDIN LIVE: Democratizing data to enhance customer-centricity. JULY 29TH REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Using Gauge Chart to display data for Max(Date)

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

3 Replies
SergeyMak
Partner
Partner

Hi

I don't know Maximum() function

I know only Max()

Regards,
Sergey
Not applicable
Author

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

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

Regards,
Sergey