topic Re: get value from variable in variable in QlikView

get value from variable in variable

Tue, 06 Aug 2013 08:22:38 GMT

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

Re: get value from variable in variable

MayilVahanan — Tue, 06 Aug 2013 08:48:32 GMT

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

Re: get value from variable in variable

CELAMBARASAN — Tue, 06 Aug 2013 08:51:22 GMT

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

Re: get value from variable in variable

Tue, 06 Aug 2013 09:40:00 GMT

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?

Re: get value from variable in variable

CELAMBARASAN — Tue, 06 Aug 2013 10:21:53 GMT

Your Scenario looks different Can you post the sample file?

Re: get value from variable in variable

MayilVahanan — Tue, 06 Aug 2013 10:22:03 GMT

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

Re: get value from variable in variable

Tue, 06 Aug 2013 22:54:13 GMT

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.