Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Sum() where property = Max()

Let's assume we have

Entity

{

     Date

     Value

}

How to Sum(Value) for the latest day?

=Som({<$Date=.........>}Value)

I'm still trying to understand the syntax, I tried several ways but without no luck.

P.S. Any article regarding syntax like this?

1 Solution

Accepted Solutions
Highlighted

=sum({$<Date={'$(=max(Date))'}>}Value)

or

=sum({$<Date={'$(=date(max(Date)))'}>}Value)

View solution in original post

1 Reply
Highlighted

=sum({$<Date={'$(=max(Date))'}>}Value)

or

=sum({$<Date={'$(=date(max(Date)))'}>}Value)

View solution in original post