topic New column by script in QlikView

New column by script

luca_bellotti — Thu, 19 Jul 2018 14:44:53 GMT

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

NAME	A	B	C	D
RED	100	98	10	50

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

TABLE2

NAME	A	B	C	D	E
RED	100	98	10	50	10,04

Thank everyone who might help me.

YoussefBelloum — Thu, 19 Jul 2018 14:50:03 GMT

Hi,

try this:

Table1:

load

FROM

TABLE2:

LOAD

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

resident Table1;

luca_bellotti — Thu, 19 Jul 2018 15:24:23 GMT

It worked. Thank you Youssef.

YoussefBelloum — Thu, 19 Jul 2018 15:26:25 GMT

You're welcome