Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community!
I am working with a qliksense app that has the information as follows in one of my tables:
TABLE 1 | ||||
PERSON 1 | PERSON 2 | PRODUCTS | OBJECTIVE | MAX OBJECTIVE |
JUAN | 1 | PRODUCT 1 | 12 | 12 |
JUAN | 1 | PRODUCT 2 | 2 | 12 |
JUAN | 2 | PRODUCT 3 | 34 | 34 |
JUAN | 2 | PRODUCT 2 | 3 | 34 |
JUAN | 3 | PRODUCT 1 | 12 | 33 |
JUAN | 3 | PRODUCT 3 | 33 | 33 |
JUAN | 4 | PRODUCT 2 | 32 | 64 |
JUAN | 4 | PRODUCT 2 | 64 | 64 |
JUAN | 4 | PRODUCT 3 | 64 | 64 |
JUAN | 5 | PRODUCT 1 | 2 | 54 |
JUAN | 5 | PRODUCT 3 | 54 | 54 |
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
PERSON 1 | RESULT |
JUAN | 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.
Thanks!!!
Sofía
Try this
Aggr(
SUM(
Aggr(
Max(OBJECTIVE)
,[PERSON 1],[PERSON 2]
)
)
,[PERSON 1]
)
Try this
Aggr(
SUM(
Aggr(
Max(OBJECTIVE)
,[PERSON 1],[PERSON 2]
)
)
,[PERSON 1]
)