If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
I am working with a qliksense app that has the information as follows in one of my tables:
I need to create a new table with person 1 as dimension and need to sumarize the max objective of each Person 2 and show it as a total for Juan.
The result should be summarizing each light blue result and in this case is 197
I tried with AGGR but without success..
aggr(SUM(Max OBJECTIVE),PERSON 1,PERSON 2)
Will really appreciate your help to sort this out.
=Sum(Aggr(Max([MAX OBJECTIVE]),[PERSON 1],[PERSON 2]))
View solution in original post
For me, you've two steps :
MAX(TOTAL <[PERSON 2]> [MAX OBJECTIVE])
SUM ( AGGR(MAX(TOTAL <[PERSON 2]> [MAX OBJECTIVE]), [PERSON 1]))
Try it and make us any feedback if it works (unfortunately, I don't try it to ensure me if it works)!