topic Re: Simple Sum Function in Load Script in QlikView

Simple Sum Function in Load Script

Tue, 30 Sep 2014 21:36:29 GMT

Hello,

I am trying to get the Sum column in the following example which is Shirts plus Pants

Account	Scarfs	Shirts	Pants	Sum
ACCT 1	$3.00	$12.50	$6.00	$18.50
ACCT 2	$6.00	$24.00	$5.00	$29.00
ACCT 3	$7.00	$0.00	$125.00	$125.00

Account, Scarfs, Shirts and Pants are fields in my data source. I want to accomplish this sum so that there is now a field called sum and it is the sum of each row for Shirts and Pants. I don't need a sumif of specifc accounts, just a sum of all accounts shirts and pants. Thanks,

Re: Simple Sum Function in Load Script

caio_caminoski — Tue, 30 Sep 2014 21:48:43 GMT

I guess you just need a simple sum like the following:

Load

Account,

Scarfs,

Shirts,

Pants,

(Shirts + Pants) as Sum

From

yourfilepath

Regards

Re: Simple Sum Function in Load Script

MarcoWedel — Tue, 30 Sep 2014 22:09:06 GMT

Hi,

if you just want to present this column, you could do so as a chart expression instead:

hope this helps

regards

Marco

Re: Simple Sum Function in Load Script

Wed, 01 Oct 2014 14:00:39 GMT

Thank you for the Replies, those answered the question perfectly.

Bill

Re: Simple Sum Function in Load Script

MarcoWedel — Wed, 01 Oct 2014 14:16:56 GMT

you're welcome.

regards

Marco