Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
IMPORTANT: Upcoming LEF Database Maintenance, Oct. 3rd - SEE DETAILS
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

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

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

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