topic Re: sum line in script in QlikView

sum line in script

Anonymous — Wed, 25 Nov 2015 04:55:25 GMT

hi,

i have 2 tables order + orderline

i need to make group for kg in order.

the kg is in the order line.

i want to make in the script feild with sum kg per order .

how do i do it ?

thanks'

yarin.

Re: sum line in script

jonathandienst — Wed, 25 Nov 2015 05:10:44 GMT

I assume that the order line has an order number field. Create a temporary table summing the mass grouping by order number, so the new table will contain order number and total mass in kg. You can then join this table to the order header or add it to the order header table with applymap().

If you provide a sample qvw with representative data, then someone will be able to provide more detailed assistance.

Re: sum line in script

tresB — Wed, 25 Nov 2015 05:33:24 GMT

Could you post a data sample with expected output explanation?

Re: sum line in script

deepakqlikview_123 — Wed, 25 Nov 2015 05:58:00 GMT

Hi,

PFA

I hope this would be your req

Thanks

Re: sum line in script

tamilarasu — Wed, 25 Nov 2015 06:05:22 GMT

I just did some modification on the file. Reload the attached file after download.