topic Using Gauge Chart to display data for Max(Date) in QlikView

Using Gauge Chart to display data for Max(Date)

Thu, 19 Jun 2014 00:44:31 GMT

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

Re: Using Gauge Chart to display data for Max(Date)

SergeyMak — Thu, 19 Jun 2014 01:13:27 GMT

I don't know Maximum() function

I know only Max()

Re: Using Gauge Chart to display data for Max(Date)

Thu, 19 Jun 2014 10:09:08 GMT

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.

Re: Re: Using Gauge Chart to display data for Max(Date)

SergeyMak — Fri, 20 Jun 2014 01:15:26 GMT

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