topic Re: Sum fields in load script in QlikView

Sum fields in load script

Fri, 20 Jun 2014 00:16:01 GMT

I want to sum the values in several fields into one "sum" field. Here's what I have so far:

LOAD customerID,

product1purchases,

product2purchases,

product3purchases,

(product1purchases+product2purchases+product3purchases) as totalpurchases

from

;

The line in bold doesn't work. I tried using sum() and that didn't work either. I know how to do this in a chart, but I want to do this in the load script if at all possible.

I feel like I'm missing something obvious. Any ideas?

Re: Sum fields in load script

Fri, 20 Jun 2014 00:22:24 GMT

PFA. It should work fine. Can you send me your script please?

Re: Sum fields in load script

Fri, 20 Jun 2014 00:38:40 GMT

That helped! I tested it and found that most of the fields had null values and these were tripping it up. If anyone reads this and has the same issue, here's what my solution was:

LOAD customerID,

product1purchases,

product2purchases,

product3purchases,

(if(product1purchases=1,product1purchases,0)

+if(product2purchases=1,product2purchases,0)

+if(product3purchases=1,product3purchases,0)) as totalpurchases

from

;

Re: Re: Sum fields in load script

Fri, 20 Jun 2014 00:53:08 GMT

Hi Sophia, In this case Rangesum would be more appropriate.

PFA the example.

Re: Sum fields in load script

Fri, 20 Jun 2014 17:27:07 GMT

Even better, thanks!