topic Re: Aggregating total sales in a expression in QlikView

Aggregating total sales in a expression

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Coud someone guide me on how to do the aggregation of the sales at co. level in a pivot table chart.

I would like to sum the total sales $ by the total sales made per company. Would like to know how to write the expression for it.

Thanks

MayilVahanan — Wed, 22 Feb 2017 10:16:31 GMT

Are you looking like this

Dim: Co. Name

Exp: =Sum(Amount) / Sum(total Amount)

vinieme12 — Wed, 22 Feb 2017 10:26:56 GMT

for total by company

Sum(Amount) / Sum(TOTAL <Co. Name> Amount)

so % for Water for SalesNo 5369 = 6,200. / (6,200+4,500)

Anonymous — Wed, 15 Mar 2017 08:50:59 GMT

Thanks, guys.. it's closed to what i need..