Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Woody
Contributor
Contributor

Wanting to sum a number field with the condition the Date field is the max.

Hi All,

Wanting to sum a number field with the condition the Date field is the max.

Below is my attempt but it's throwing nothing back. 

Sum({<DATA_DATE=Max(<DATA_DATE>)>}TOTAL [VOL_P])

 

Can someone help with this please.

1 Solution

Accepted Solutions
arulsettu
Master III
Master III

Try like this

 

Sum({<DATA_DATE={'$(=Max(DATA_DATE))'}>}TOTAL [VOL_P])

View solution in original post

2 Replies
arulsettu
Master III
Master III

Try like this

 

Sum({<DATA_DATE={'$(=Max(DATA_DATE))'}>}TOTAL [VOL_P])

View solution in original post

Woody
Contributor
Contributor
Author

Hi,

Would it be possible to explain the syntax in the solution so that I get a better understanding.