topic Re: Copy variable in QlikView

Copy variable

jduenyas — Wed, 25 Nov 2020 16:16:04 GMT

Hello gurus

I have created a new document with a Binary load from an existing one.

However, variables are not being copied/transferred with the Binary load.

Is there a way to copy all variables (i have many of them) from the existing document to the new?

Thanks

Re: Copy variable

petter — Wed, 05 Feb 2020 18:29:25 GMT

Yes the variables are not part of the data model of QlikView or Qlik Sense.

And yes there is a way of getting hold of the variables by reading them from the QVW-file. The QVW-file has an XML-section where the variables are accessible.

You will have to read the QVW-file from a load script with a LOAD statement using XML as the file format. Then you will get all the variables into a table. The table can be parsed with a simple FOR loop afterwards to recreate each and every variable.

Re: Copy variable

petter — Wed, 05 Feb 2020 18:40:20 GMT

Another approach is to make a QlikView macro with either VBScript or JScript (JavaScript). There is an API that let you manipulate and read anything in a QlikView document - variables are also fully accessible this way.

Furthermore there are applications being made as "open-source" to do the job:

Re: Copy variable

jduenyas — Wed, 05 Feb 2020 18:41:35 GMT

Thanks.

A little more help... Using QlikView not QlikSense

Where can the XML section be found?

Re: Copy variable

petter — Wed, 05 Feb 2020 19:19:05 GMT

This is how you can retrieve the variable info:

VARIABLE: LOAD Name, IsConfig, IsReserved, RawValue FROM [C:\Program Files\QlikView\Examples\Documents\Getting Started.qvw] (XmlSimple, Table is [DocumentSummary/VariableDescription]);

Re: Copy variable

jduenyas — Wed, 05 Feb 2020 19:22:20 GMT

You are the BEST!!!

Thanks for your help

Re: Copy variable

rwunderlich — Thu, 06 Feb 2020 02:15:20 GMT

This blog post contains the code to both load and recreate the variables: https://qlikviewcookbook.com/2018/06/loading-variables-from-another-qvw/

Re: Copy variable

jduenyas — Thu, 06 Feb 2020 15:55:26 GMT

Thank you Rob.

You always come through!

What would we do without you? 😊

Re: Copy variable

sayalip — Sat, 08 Feb 2020 18:38:10 GMT

That script helps to get variables in application but my question is how we can create variable in application . Any suggestions?

Re: Copy variable

sayalip — Sat, 08 Feb 2020 18:40:18 GMT

I am using that script i have imported 100 variables now i want a script using that i can create all variable in my application instead of manual work. is it possible.

Re: Copy variable

petter — Sat, 08 Feb 2020 19:55:52 GMT

Yes - and if you read the link that Rob suggested you will find code to do exactly that.

Quoting from his post it will look like this:

FOR idx=0 to NoOfRows('VARIABLE')-1
 LET vVarname = Peek('Name',$(idx),'VARIABLE');
 LET [$(vVarname)] = Peek('RawValue',$(idx),'VARIABLE');
NEXT idx

SET idx=;
SET vVarname=;
DROP Table VARIABLE;

Re: Copy variable

jduenyas — Mon, 10 Feb 2020 22:25:25 GMT

In any of the sheets type

<Ctrl><Alt> v this will open a dialog box to create variables. Click Add, name your variable and then enter the formula/reference/fields that you would like to use in a variable name.

Did this help?