topic Re: Export Variables from an application. in QlikView

Export Variables from an application.

Wed, 11 Jul 2012 04:13:38 GMT

Hi,

Is there any way by which we can export all the variables created in the application (During the reloading or development).

Vivek

Re: Export Variables from an application.

nagaiank — Wed, 11 Jul 2012 04:40:49 GMT

One way of doing this is to create all variables in the script and export the script file from which the variables can be created. Probably this is a good practice as this documents all the variables in the application.

Re: Export Variables from an application.

Anonymous — Wed, 11 Jul 2012 04:44:49 GMT

1. Create an input box

2. Click Add All to list all variables

3. Send to Excel

Re: Export Variables from an application.

Wed, 11 Jul 2012 05:31:22 GMT

hi Johannes,

thxs for the reply... i have tried this approach but the variables that are declared with the '=' displays the result rather than the expression.

how can i export the exact expression of the variables which has the expression starting with '='?

Re: Export Variables from an application.

giakoum — Wed, 11 Jul 2012 05:36:35 GMT

It seems that Johannes is right. See attached example.

Re: Export Variables from an application.

Anonymous — Wed, 11 Jul 2012 05:49:46 GMT

Yeah Vivek,

You're right. Didn't think about that one

Re: Export Variables from an application.

Wed, 11 Jul 2012 05:53:06 GMT

hi,

the example shared by you doesnot contain '=' sign before the expression...so the result is the whole expression but if the expression is declared with '=' sign at the begining then it doesn'tshow the expression but the result of the expression.

See the attached file.

Re: Export Variables from an application.

nagaiank — Wed, 11 Jul 2012 06:01:45 GMT

For this exact reason, I suggested to include the expression for defining the variable in the script and export the script with the expression.

Re: Export Variables from an application.

giakoum — Wed, 11 Jul 2012 06:05:30 GMT

sorry yes you are right. Is it a one time thing or you need to export the expressions over and over again?

Re: Export Variables from an application.

Wed, 11 Jul 2012 06:14:55 GMT

no its a one time thing...actually the thing is that the applications have very complex expressions defined in them. so i wanted to export all the expressions for safe keeping.

Re: Export Variables from an application.

giakoum — Wed, 11 Jul 2012 06:29:08 GMT

then you could remove the = in a copy of your application and use Johannes approach.

But maybe this way works also :

LOAD

'$(Variable1)' as Variable1

,'$(Variable2)' as Variable2

AutoGenerate(1);

STORE [3] into c:\Variables.txt (txt);

Re: Export Variables from an application.

Wed, 11 Jul 2012 06:45:40 GMT

thnxs a lot...

Re: Export Variables from an application.

Mon, 20 Mar 2017 12:40:25 GMT

Superb, for new users like me, this is very useful. Thanks

Re: Export Variables from an application.

Anonymous — Fri, 19 Jan 2018 09:26:55 GMT

In order to fetch those variables that contain formulas you might go to:

Settings, Expression Overview (Ctrl+Alt+E)

Check "Other Expressions"

They are listed at the end, without Variable name in the first place.

So click the Button "Column" and choose "Location(Full)"

That contains information on the variable name

You can export this and get rid of the unnecessary "<Document>.<Variable="xxx">" construct with an easy general search/replace in any text editor easily.

If you want to transfer the definition of you variables into the load script, you might give a try to the following approach:

I use RegEx here. For those who are not familiar with it, you might find your own way. What we do here is basically add a line for each variable int the load script that is like

LET Variable = 'Expression'

It has to be LET, not SET in order to work properly.

You must not have apostrophes in your expressions, so you have to split the expressions and concatenate them with chr(39) again as chr(39) stands for an apostrophe.

So this is how you bring the magic of RegEx into this:

If you use an editor that supports RegEx (Notepad++), you can transform the Export to a QlikView load script by searching

(\n\t*<Document>\.<Variable=)(.*)(>\t)(.*)(\r)

and replace it by

LET $2 = '$4';

(in RegEx mode)

If your expressions contain apostrophes, you FIRST need to replace these by searching for

and replace it by

'&chr$39$&'

(in RegEx mode)

or by

'&chr(39)&'

(in standard mode)

If your expressions contain $ sign expansion, you need to replace these dollar signs by searching for

(in RegEx mode) or

(in regular mode)

and replace it by

'&chr$36$&'

(in RegEx mode)

or by

'&chr(36)&'

(in standard mode)

That gives you a series of LET expressions that you can easily paste into the load script.

Any later changes to you variables definitions has to happen in the oad script then, as it woul get overwritten any time you run the load script again.

If you need the "other" variables (those not containing a formula) as well in the load script, you might follow Johannes apporach, transform the output in Excel to SET expressions with an Excel formula like ="SET "&A1&" = "&C1&";" and paste this into the QlikView load script before the above generated LET expressions.

That way, you get all variables where the ones that are defined by a formula are also still defined as formula because the following LET overwrite the (in these cases wrong) SET definitions.

Re: Export Variables from an application.

prbnrs11 — Wed, 04 Jul 2018 09:35:16 GMT

Thank you so much. You are awesome