topic variable in table and evaluate in QlikView

variable in table and evaluate

amien — Wed, 19 Jun 2013 10:32:27 GMT

I havd a table which contains two fields:kpi_name and variable_name

for example

kpi_name , variable_name

1 , vFormula1.Expr

2 , vFormula2.Expr

is it possible to create a pivot with kpi_name as dimension and variable_name as expression. BUT the expression should also be evaluated

=$(=variable_name)

This will give me the right expression for each kpi_name, but it's not evaluated

Thanks in advanced

Re: variable in table and evaluate

Gysbert_Wassenaar — Wed, 19 Jun 2013 11:09:22 GMT

If you have a field named variable_name that contains the names of variables that contain expressions you can use the variable_name field in expressions like this $($(=variable_name)) to evaluate the expression in the variable with the same name as the selected value of variable_name.

Re: variable in table and evaluate

amien — Wed, 19 Jun 2013 11:39:22 GMT

Tnx