Qlik: Avoiding average in expression

[#1]

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.

[rphpacheco]

Try:

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

[Nicole-Smith]

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

[#4 · Accepted solution]

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