Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
robert_mika
Master III
Master III

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

View solution in original post

4 Replies
robert_mika
Master III
Master III

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
Not applicable
Author

Oh my,,,how simple.

Thx!

maxgro
MVP
MVP

it seems you already have the answer

LOAD

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

  Konto,

  Data

From xyz;

robert_mika
Master III
Master III

I had tunnel vision....

Philip please use Massimo solution..