How to pull back only the sum of the most recent date

[williamdeboos]

Hi there,

Within a chart, I would like to build an expression that will pull back the sum of the most recent value. I am trying to pull back using max(Date) logic but am failing. Any ideas?

This is what I have so far....

=sum(if(Date=max(Date),[Value(USD)],0)

Many thanks.

[sonkumamon · Accepted solution]

You need to put the date in Set Analysis, something like this:

Sum{< Date = {'=Max(Date)'} >} [Value(USD)])

For more information, refer to

https://help.qlik.com/en-US/sense/February2020/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/SetAn...

[sunny_talwar]

Do you want the result for the Max value across the whole dashboard or Max date on certain dimension/s?