topic Re: Grand total query in QlikView

Grand total query

ramanarayan — Sat, 16 Nov 2024 20:12:40 GMT

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.

Re: Grand total query

jensmunnichs — Fri, 23 Aug 2019 10:11:09 GMT

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

Re: Grand total query

ramanarayan — Fri, 23 Aug 2019 10:30:52 GMT

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

Re: Grand total query

jensmunnichs — Fri, 23 Aug 2019 10:59:17 GMT

Hey,

How about this?

Re: Grand total query

sugathirajkumar — Fri, 23 Aug 2019 11:48:06 GMT

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)