Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
tabisen1
Contributor II
Contributor II

Sumproduct of actual Quantity and Target Cost

Dear All,

Hope all are safe and healthy in covid-19 condition.

I need urgent help on the below. I have created the  Pivot table in QlikView I stuck in the Below working where I have to do the sum product of Actual Quantity and Trade Cost as shown in below table marked with Red color and Sum of all marked with maroon color.  

 

File attached below

Table Required  

tabisen1_3-1615640761891.png

 

Pivot table created in QlikView want to add Marked with Maroon color and want to delete the nos. marked with Blue Color. 

tabisen1_5-1615640865193.png

 

 

Need support to finish my work.

Regards,

Tarun Bisen

 

 

Labels (1)
1 Reply
Frank_Hartmann
Master II
Master II

try to enclose your expression/s with sum(aggr( at the beginning and ,PLANTNAME,REGION,DEPOT,TALUKA)) at the end. This should show the correct Totals.