Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
ramanarayan
Creator
Creator

Grand total query

HI 

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

 

Output.PNG

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.

 

 

 

Labels (2)
4 Replies
jensmunnichs
Creator III
Creator III

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
Creator
Creator
Author

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
Creator III
Creator III

Hey,

How about this?

sugathirajkumar
Creator
Creator

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)