# New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for
Did you mean:
Highlighted
Contributor

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

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.

1 Solution

Accepted Solutions
Highlighted
Contributor III

## Re: How to pull back only the sum of the most recent date

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

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

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

2 Replies
Highlighted
Contributor III

## Re: How to pull back only the sum of the most recent date

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

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