AGGR FORMULA

[sguerra2]

Virtual table question

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

[sguerra2]

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

[PradeepK · Accepted solution]

Try this

Aggr(
	SUM(
    	Aggr(
        	Max(OBJECTIVE)
            ,[PERSON 1],[PERSON 2]
            )
       ) 
    ,[PERSON 1]  
)

[sguerra2]

Thanks @PradeepK ! it is working 🙂

Best Regards.

Sofía