topic Aggregating and Calculating % in QlikView

Aggregating and Calculating %

Thu, 05 Feb 2015 19:18:18 GMT

Hello,

I am new user of Qlikview and am trying to calculate the % for each product based on the following data set.

Type	Account	Product	Units
A	XX	ABC	10
A	XX	DEF	50
A	XX	GHI	72
A	YY	ABC	62
A	YY	DEF	17
A	YY	GHI	46

I need the results to be as follows

Type	Account	Product	%
A	XX	ABC	7.58%
A	XX	DEF	37.88%
A	XX	GHI	54.55%
A	YY	ABC	49.6%
A	YY	DEF	13.6%
A	YY	GHI	36.8%

Please advise on most optimal way of doing this.

Thanks

marcus_sommer — Thu, 05 Feb 2015 19:23:48 GMT

Try something like this in a pivot-expression: sum(value) / sum(total <Type, Account> value)

- Marcus

maxgro — Thu, 05 Feb 2015 19:28:14 GMT

sum(Units) / sum(TOTAL <Account> Units)