Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
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

Highlighted
Creator
Creator

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

Highlighted
Creator III
Creator III

Hey,

How about this?

Highlighted
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)