topic Calculate Indicator in Script in QlikView

Calculate Indicator in Script

Anonymous — Thu, 19 Mar 2015 15:24:06 GMT

Hi,

i need to calculate a column in script for existing table:

I have a table like:

LOAD

Konto,

Data

From xyz;

And the calculated field should look like:

If(Data>0, Belastung, Entlastung) as Indicator

How can in achieve this?

robert_mika — Thu, 19 Mar 2015 15:36:16 GMT

t1:

LOAD Konto,

Data

FROM

[..\Desktop\Book1.xlsx]

(ooxml, embedded labels, table is Sheet1);

t2:

load

Konto,

If(Data>0, 'Belastung', 'Entlastung') as Indicator

resident t1;

drop table t1

Anonymous — Thu, 19 Mar 2015 15:43:01 GMT

Oh my,,,how simple.

Thx!

maxgro — Thu, 19 Mar 2015 15:47:51 GMT

it seems you already have the answer

LOAD

If(Data>0, 'Belastung', 'Entlastung') as Indicator,

Konto,

Data

From xyz;

robert_mika — Thu, 19 Mar 2015 16:12:36 GMT

I had tunnel vision....

Philip please use Massimo solution..