topic Re: Calculated column in load script in QlikView

Calculated column in load script

Mon, 24 Nov 2014 15:53:54 GMT

Hello,

I'm loading a table from an excel file, I'd like to create a column with calculate values like this:

Load

[value A],

[value B],

[value C],

[value A] + [value B] + [value C] as vSUM // the new calculated column

FROM

[data.xls]

(biff, embedded labels, table is [Elenco dati contabili$]);

How can I do that?

Thank you.

Lorenzo

Mon, 24 Nov 2014 15:57:41 GMT

The way you have it should work, if there are nulls in your data you may need to do...

alt([value a], 0) + alt([value b], 0) + alt([value c], 0) as vSUM

simondachstr — Mon, 24 Nov 2014 15:59:52 GMT

Use rangesum() instead of multiple alt() - it automatically turns null() into 0.

alexandros17 — Mon, 24 Nov 2014 16:03:47 GMT

Hi Lorenzo,

remember that with front end objects you can always do the sum so I wonder if thet total is really useful ... if it is use rangesum ...

Tue, 25 Nov 2014 09:40:37 GMT

Hi, which is the syntax of rangesum()? How can I use it?

Thanx

anbu1984 — Tue, 25 Nov 2014 09:50:50 GMT