Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

aut_phil
Contributor

Calculate Indicator in Script

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?

1 Solution

Accepted Solutions

Re: Calculate Indicator in Script

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

4 Replies

Re: Calculate Indicator in Script

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

aut_phil
Contributor

Re: Calculate Indicator in Script

Oh my,,,how simple.

Thx!

MVP
MVP

Re: Calculate Indicator in Script

it seems you already have the answer

LOAD

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

  Konto,

  Data

From xyz;

Re: Calculate Indicator in Script

I had tunnel vision....

Philip please use Massimo solution..

Community Browser