Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
luca_bellotti
Contributor III
Contributor III

New column by script

Hello to everyone,

I've tried to solve this problem but I can't figure it out. Maybe someone  could help me.

I've loaded the TABLE1 by script editor

TABLE1

NAMEABCD

RED

100981050

What I need to obtain is a new table with another column  (E) with the following formula C+((A-B)/D)

TABLE2

NAMEABCDE

RED

10098105010,04

Thank everyone who might help me.

1 Solution

Accepted Solutions
YoussefBelloum
Champion
Champion

Hi,

try this:

Table1:

load

.

.

FROM

TABLE2:

LOAD

C+((A-B)/D) as E

resident Table1;



View solution in original post

3 Replies
YoussefBelloum
Champion
Champion

Hi,

try this:

Table1:

load

.

.

FROM

TABLE2:

LOAD

C+((A-B)/D) as E

resident Table1;



luca_bellotti
Contributor III
Contributor III
Author

It worked. Thank you Youssef.

YoussefBelloum
Champion
Champion

You're welcome