Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Adding columns values while load

Hello,

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?

thanks,

Manoj

1 Solution

Accepted Solutions
Highlighted
Not applicable

try it

rangesum(a,b,c) as d

View solution in original post

6 Replies
Highlighted
Specialist
Specialist

Hi,

Make sure your script like this.

table1:

Load *, (A+B+C) as D;

Load *

FROM

(ooxml, embedded labels, table is Sheet1);

this should do.

BR,

chinna

Highlighted
Not applicable

Hi Chinna,

I did try preceding load but it did not work either. Let me try again and check.

thanks,

Manoj

Highlighted
Not applicable

try it

rangesum(a,b,c) as d

View solution in original post

Highlighted
Not applicable


Hi,

Use numsum(A+B+C) as D

or else try to use resident load.

table1:

Load *

FROM

(ooxml, embedded labels, table is Sheet1);

Table2:

Load *,

         A+B+C as D,

         Numsum(A+B+C) as D1

Resident table1;

Drop table1;

Highlighted
Not applicable

That works. Thanks.

Manoj

Highlighted

very good.

So the trick was to treat null and non-numeric values as 0, like the range functions do.

regards

Marco