topic Re: Qlik: Avoiding average in expression in QlikView

Qlik: Avoiding average in expression

Mon, 30 Jun 2014 14:49:25 GMT

Hi,

Whenever I have expressions in Charts, tables etc Qlik shows averages. When I include the date dimension in the Chart, the trend values look okay. I have some representations that need the expression value only for the max date.

The field having the date value is DATE and whenever I use an expression:

Sum({$ <DATE={MAX(DATE)} Metric)

I get a null on the chart. Please help.

Re: Qlik: Avoiding average in expression

rphpacheco — Mon, 30 Jun 2014 15:05:07 GMT

Try:

Sum({$ <DATE={'$(=MAX(DATE))'} Metric)

Re: Qlik: Avoiding average in expression

Nicole-Smith — Mon, 30 Jun 2014 15:07:25 GMT

Sum({$<DATE={'$(=date(MAX(DATE)))'} Metric)

Re: Qlik: Avoiding average in expression

Mon, 30 Jun 2014 15:14:37 GMT

Thanks Raphael and Nicole but that did not help

Sum({$<DATE={'$(=date(MAX(DATE)))'}>} Metric)

I assume the part in bold (on Nicole's post) was missing and that did the trick