topic Re: Sum a column in QlikView

Sum a column

e_guerra — Mon, 08 Dec 2014 19:54:06 GMT

Hello everyone

I'm new in Qlik and have a doubt...

I have a pivot table with many columns but one of them is the next expression: sum(Volume)*(Sum(Aggr(Avg(Price),[Commercial name])))

then i would like to get the total sum of that column in another one, how can i do that??

Thanks in advance

its_anandrjs — Mon, 08 Dec 2014 20:26:23 GMT

Hi,

Can you elaborate more or share the sample data or you try with

Sum(Volume) * (Sum(TOTAL Aggr(Avg(Price),[Commercial name] ) ) )

Regards

Anand

e_guerra — Mon, 08 Dec 2014 21:43:56 GMT

Hi Anand

Sure in the 4th column (Volume*Price) is the expression: sum(Volume)*(Sum(Aggr(Avg(Price),[Commercial name])))

and in the next column (sum Vol*Price) i need to sum each value of the previous column, and your expression doesn't work