get value from variable in variable

[#1]

I would like to get the value that store in another variable, like below:

Variable:

load * inline

[ ID, Rule, Total

1, 1.1.1, v111Total

2, 1.1.2, v112Total

];

v111Total and v112Total are variable that store in the QlikView,

e.g. v111Total = 100, v112Total = 156

And then I want to get the value from the column of Total for each record.

How to get it

[MayilVahanan]

HI

Try like this

Let  v111Total = 100;

Let v112Total = 150;

Load ID, Rule, Evaluate(Total) as Total;

load * inline

[ ID, Rule, Total

1, 1.1.1, $(v111Total)

2, 1.1.2, $(v112Total)

];

Hope that helps

[CELAMBARASAN]

You can use Evaluate to do that

Try the below script

Variable:

load *, Evaluate(TotalVariableName) AS Total  inline

[ ID, Rule, TotalVariableName

1, 1.1.1, v111Total

2, 1.1.2, v112Total

];

Hope it helps

Celambarasan

[#4]

Thank you for your reply.

But if the variable is changed in the QlikView App, the value of variable can not sync at the same time.

And the Evaluate can not be used in the chart.

Is there any other solution?

[CELAMBARASAN]

Your Scenario looks different Can you post the sample file?

[MayilVahanan]

HI

Please check with Inputfield concept

A field may flagged as an input field by listing it in an inputfield statement before it is referenced in any load or select statements.

Input fields behave somewhat differently from regular fields. The most important difference is their ability to accept changes in field values, interactively or programmatically, without running the script. Field values must be loaded into the field via load or select statements. Each field value loaded in the script will create a placeholder for a field value replacement value. Only existing field values can thus be changed interactively or programmatically. In input fields all field values will be treated as distinct, regardless if several have the same value.

The syntax is:

inputfieldfieldlist

fieldlist is a comma separated list of the fields that should be flagged as input fields. The wildcard characters * and ? are allowed in field names. Quoting of field names may be necessary when wildcards are used.

Examples:

Inputfield B;

Hope it helps

[#7]

Hi all,

My App is a rule check program, I want to add a summary page in the App. So, I want to add all rule into one table like below:

Variable:

load * inline

[ ID, Rule, Total

1, 1.1.1, v111Total

2, 1.1.2, v112Total

];

And then I will show this table in the summary page, but I want to show the total value in the chart, at this situation I want to get the value from each variable. All the variables will be changed, and in the summary page should keep the consistency.