Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
zarmoton
Creator
Creator

Bug in the SUM

Hi

I need to have the value 1  (in the 3 rows) , and not 18 in SUM of MAX GRADE.

(1 is AMOUNT = -10 + 11)

I have wrote this expression , but not working:

= Sum({<GRADE = {"=Max(TOTAL <MyDate, [Site Number]> GRADE)"}> } TOTAL <MyDate, [Site Number]> AMOUNT)

Screen Shot 05-10-20 at 01.59 PM.PNG

 

Thk yu for your help

Regards

1 Solution

Accepted Solutions
zarmoton
Creator
Creator
Author

I found it !

= Sum({<GRADE = {"=Max(TOTAL <MyDate, [Site Number]> GRADE)=GRADE"}> } TOTAL <MyDate, [Site Number]> AMOUNT)

View solution in original post

1 Reply
zarmoton
Creator
Creator
Author

I found it !

= Sum({<GRADE = {"=Max(TOTAL <MyDate, [Site Number]> GRADE)=GRADE"}> } TOTAL <MyDate, [Site Number]> AMOUNT)

View solution in original post