Qlik Community

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 
Search instead for 
Did you mean: 
Highlighted
Contributor
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
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)])

For more information, refer to

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

View solution in original post

2 Replies
Highlighted
Contributor III
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)])

For more information, refer to

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

View solution in original post

Highlighted

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

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