Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Variable calls variable in LOAD

Hi,

I am stuck with my variables but I am sure there is a simple answer that i d'ont see. If someone can help, it would be great!

In Excel source files, I have a master list of ID and Formulas.

In my script, I've created a variable for each ID. Each variable name is the ID.

Sourcefile:

ID       Formula

F01     Field1 + Field2

F02     Field1 * Field2

In this example, I got 2 variables then: F01 and F02.

In my script, I have a table for which , for each record, I have different fields and a field containing the ID of formula.

This table contains also the Field1 and Field2.

What I would like is to add to that table a column with the result of the formulas.

MyTable:

FieldA FieldB FieldC Field1 Field2 Formula

test1   bb       cc       10      15      F01

test2   bb       cc       10      15      F02

Should give me:

MyTable2:

FieldA FieldB FieldC Field1 Field2 Formula  Result

test1   bb       cc       10      15      F01         25

test2   bb       cc       10      15      F02         150

Any ideas?

Thanks!