topic Re: Total sum of specific field during loading script in QlikView

Total sum of specific field during loading script

atsushi_saijo — Wed, 21 Jan 2015 13:37:56 GMT

Could we create a value and assign sum (=total) of specific column of a table, during the loading script?

[Example]

We have such source data. I needed to create a value, which is Sum(TOTAL Weight) during loading, and create value, like:

Let vTotalWeight = Sum(TOTAL Weight) Resident DeliveryNote

PalletID	BoxID	Weight
1	A	5
1	B	3
2	C	8
3	D	4

****************************************

Let's create on QlikView. Above is:

DeliveryNote: Load * Inline [

PalletID,BoxID,Weight

1,A,5

1,B,3

2,C,8

3,D,4

] (delimiter is ',')

Could we create a value of total sum of Weight?

[Background]

I was trying creating an EDI source data (that will be further converted by the VAN vendor). In typical ASN message based on Delivery Note, we needed to place a total weight per delivery. Headers requires such values.

I appreciate for your advises in advance.

Re: Total sum of specific field during loading script

rwunderlich — Wed, 21 Jan 2015 13:59:37 GMT

TotalWeight_temp:

LOAD Sum(Weight) as TotalWeight Resident DeliveryNote;

Let vTotalWeight = peek('TotalWeight ');

DROP TABLE TotalWeight_temp;

-Rob

Re: Total sum of specific field during loading script

atsushi_saijo — Wed, 21 Jan 2015 15:21:36 GMT

Thank you for fast reply.

Re: Total sum of specific field during loading script

Shubham_Deshmukh — Thu, 13 Dec 2018 09:18:47 GMT

how to join total in inline data