Discussion board where members can get started with QlikView.
I have a excel file that has 3 value fields (columns) A, B and C that I want to add to get another column D.
"LOAD A + B + C as D" doesn't work somehow. I can of course create the D column in the source file while adding A, B and C, but is there a way I can sum A, B and C while loading?
rangesum(a,b,c) as d
View solution in original post
Make sure your script like this.
Load *, (A+B+C) as D;
(ooxml, embedded labels, table is Sheet1);
this should do.
I did try preceding load but it did not work either. Let me try again and check.
Use numsum(A+B+C) as D
or else try to use resident load.
A+B+C as D,
Numsum(A+B+C) as D1
That works. Thanks.
So the trick was to treat null and non-numeric values as 0, like the range functions do.