topic Re: Variables in QlikView

Variables

svsudhakar — Wed, 14 May 2014 06:10:38 GMT

Hi ,

Is any possible to copy the variables from one application to another application ?

Ex:

I have created more than 100 variables in my application. I have to copy all variables from one app to another application. Please suggest on this.

Regards,

Sudhakar

Re: Variables

alexandros17 — Wed, 14 May 2014 06:16:44 GMT

Unfortunately it is not possible,

the solution is to create variables in the script with LET and SET instructions.

Re: Variables

Wed, 14 May 2014 06:16:56 GMT

You can use an include script instead of creating it in qvw file.

Shameem.

Re: Variables

jonathandienst — Wed, 14 May 2014 06:59:53 GMT

You can extract the variables using a script like this:

Let zFileName = 'C:\Projects\Project1\Model.qvw';

VariableDefinition:

LOAD

Name As Variable.Name,

RawValue As Variable.Definition

FROM [$(zFileName)] (XmlSimple, Table is [DocumentSummary/VariableDescription])

Where Not(IsReserved = 'true' Or IsConfig = 'true');

For i = 0 to NoOfRows('VariableDefinition') - 1

Let zVarName = Peek('Variable.Name', i, 'VariableDefinition');

Let zVarValue = Peek('Variable.Definition', i, 'VariableDefinition');

Let $(zVarName) = zVarValue;

Set the value of zFileName to the model from which you would like to get the variables.

HTH

Jonathan

Re: Variables

maleksafa — Wed, 14 May 2014 11:15:53 GMT

Hi,

you can download an external plugin called QVPlus, you have the possibility to export variables from there.

Re: Variables

svsudhakar — Thu, 15 May 2014 03:44:39 GMT

Hi Jonathan,

Thanks for your quick response.

I am getting an error while executing the above script,

could you please provide me an sample application for this.

Regards,

Sudhakar

Re: Variables

svsudhakar — Thu, 15 May 2014 03:47:28 GMT

Hi Shamshunnisa,

I have created all the variables through variable overview -->setting option.

could you please tell me how can I export the variable script to import in other application.

regards,

sudhakar

Re: Re: Variables

Thu, 15 May 2014 05:56:36 GMT

The code given by Jonathan is working. You should replace 'C:\Projects\Project1\Model.qvw'; as per your required file path. Hope you have done that. We can help you if can share the error message or the application with us.

Attaching files for your reference. Variables in Sales dashboard-copy.qvw are extracted to variables.qvw file.

Shameem.