Copying variables from an application to a second one

[oxiofrt]

Hi,

I have two application which are quite similar. One of them is containing many variables that I would like to create as well to the other application. Is there another for doing it than simply creating them manually one by one ?

Thanks a lot for your help

[Anonymous]

Variables as in Script Variables??

Script you can open and copy pretty easily ...

[#3 · Accepted solution]

1) Create an InputBox

2) Add all the variables that you want to copy

3) Copy the InputBox object

4) Paste it in destination document

5) Done. The variables are also copied.

[oxiofrt]

Great, thanks a lot

[#5]

Wanted to bump this post as I have a question.

When I copy the input box to my new application, it copies the variable names (which also now appear in my variable list), but not the variable expressions.  This column is blank??

Thanks

Gareth

[mphekin12]

Gareth,

Did you ever find a way to copy both the variable name and it's value between applications?

Thanks!

[#7]

mphekin12‌

There is a way to do this. In your source app, click right on the inputbox and send the contents to Excel.

You now have an exceldocument with the variable names in column A, an '=' in column B and the variable values in column C.

Add the following formula to column 😧

="LET "&A1&" = '"&C1&"';"

Copy and paste column D into your load-script, reload, and tadaa... all variables now have the values from the source-document

You can delete the added lines from your load script afterwards.

Good luck!

[mphekin12]

Thanks Paul!

[jonbmorrison]

Will this work as well in Qlik Sense (3.0 currently)?

I've found another thread describing a way to extend QS to include an InputBox - but wondering if this solution is valid in Sense as well.

Thanks

[Anil_Babu_Samineni]

Here, how it is possible to copy one file object to another file