Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
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