Grand total query

[ramanarayan]

HI 

For the attached data , I need the following output as value in "Straight Table"

A shipment qty and B shipment qty are the sum of all the rows by products

Shipment delta is the absolute value of the difference b/w A shipment qty and B shipment qty

Shipment % should be 7011/1078073  (sum of A shipment qty)

Can someone replicate this logic in qlikview and share with us. Appreciate the help.

[jensmunnichs]

Hi,

Have a look at the attached file. Is that what you wanted?

I've included 2 calculations for Shipment Delta and Shipment %,  the first assumes your actual data (if your attached file is just a sample) includes the 'Shipment Delta' column. The second calculation only uses the first 2 columns of your data.

Let me know if you need any more help!

EDIT: I somehow attached your data instead of the qvw... my bad, fixed now

[ramanarayan]

Hi,

Thanks for your reply.

Actually Col D and Col E (in the last attached file) are calculated fields. We have now deleted the the columns in source file (new file uploaded now). Can you please help with the expression to derive the required output

[jensmunnichs]

Hey,

How about this?

[sugathirajkumar]

I couldnt find out the data which you attached ..for summing up the rows use' rangesum' function
and to find the Shipment Delta 'Sum(total A)-Sum( total B)
Shipment % - (Sum(total A)-Sum( total B))/sum( Total A)