topic Re: Copying variables from an application to a second one in QlikView

Copying variables from an application to a second one

oxiofrt — Thu, 17 Dec 2009 17:52:16 GMT

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

Copying variables from an application to a second one

Anonymous — Thu, 17 Dec 2009 18:03:02 GMT

Variables as in Script Variables??

Script you can open and copy pretty easily ...

Copying variables from an application to a second one

Thu, 17 Dec 2009 20:52:49 GMT

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.

Copying variables from an application to a second one

oxiofrt — Thu, 17 Dec 2009 21:17:35 GMT

Great, thanks a lot

Copying variables from an application to a second one

Wed, 01 Jun 2011 07:58:53 GMT

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

Re: Copying variables from an application to a second one

mphekin12 — Wed, 08 Oct 2014 17:51:50 GMT

Gareth,

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

Thanks!

Re: Copying variables from an application to a second one

Mon, 04 Jul 2016 13:58:42 GMT

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!

Re: Copying variables from an application to a second one

mphekin12 — Tue, 05 Jul 2016 11:21:21 GMT

Thanks Paul!

Re: Copying variables from an application to a second one

Jon_M — Mon, 18 Jul 2016 17:12:52 GMT

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

Re: Copying variables from an application to a second one

Anil_Babu_Samineni — Mon, 18 Jul 2016 18:20:41 GMT

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

Re: Copying variables from an application to a second one

madarnavle — Tue, 12 Feb 2019 06:37:13 GMT

Hi,

It was working on QV11.2 not working in QV 12

Re: Copying variables from an application to a second one

rogeriogyn — Sat, 07 Mar 2020 14:05:31 GMT

You can use qdevops command from https://github.com/rogerio-faria/qdevops

qdevops -u=desktop -v=export,c:\myapp.qvf,vars.txt

Once, the variable are stores in vars.txt, just import to the other qvf

qdevops -u=desktop -v=import,c:\myotherapp.qvf,vars.txt

It also work for server, and to master items