Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Problem with sum

Hi,

I would like to have the sum that shows only values for the YearMonth that has maximum value. This YearMonth is generated by mastercalendar. I don't know what is wrong, but id doesn't work. if I take Max(YearMonth) separately it shows proper value i.e. 201609, but if it is in the formula shown below - it doesn't work.

sum(${<YearMonth=${Max(YearMonth)}>}Amount)

Maciek

1 Solution

Accepted Solutions
Silambarasan1306
Creator III
Creator III

Try With this,

Your expression should be like this,

Sum({<YearMonth={"$(=Max(YearMonth))"}>}Amount)

View solution in original post

3 Replies
pathiqvd
Creator III
Creator III

Hi,

   you have written wrong expr try this, 

   

    sum({<YearMonth={$(=max(YearMonth))}>}Amount)

Regards,

Silambarasan1306
Creator III
Creator III

Try With this,

Your expression should be like this,

Sum({<YearMonth={"$(=Max(YearMonth))"}>}Amount)

Anonymous
Not applicable
Author

Both works fine thanks silambarasan1306‌ and pathiqvd‌.