Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

Sum a column

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

2 Replies
Highlighted

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

Highlighted
Contributor
Contributor

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

Captura de pantalla 2014-12-08 15.36.19.png