sum distinct aggregation

Tue, 05 Jun 2012 14:25:00 GMT

hi all,

i have a case here,

as shown on the sample picture here,

on the picture,i got a pivot table that shows a groups and their shareholder debts,

that each group has subsidiaries, and a company has shareHolders that each shareholder has account that refers to the loan/debt,

the question is when i sum([totalDebt]) the result will sum all debt no matter the shareholders are in one company or many company (holder2 and holder4),

so the result is 51200, but in this case the desired result is 32100

i've been trying to use aggregation function to distinct each holder's debt sum as

(Sum(Aggr(DISTINCT [PH],shareholder))) , but the result seems wrong,

could anyone help me please, thank you all

sum distinct aggregation

Wed, 06 Jun 2012 21:00:10 GMT

Hi,

Can you provide a qlikview file with sample data?

Regards,

http://quickdevtips.blogspot.com/

sum distinct aggregation

Thu, 07 Jun 2012 03:48:07 GMT

hi bilge,

thank you

i already attached the qlikview file and sample data

topic sum distinct aggregation in QlikView

sum distinct aggregation

sum distinct aggregation

sum distinct aggregation