Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Partner
Partner

Copying variables from an application to a second one

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

Tags (1)
1 Solution

Accepted Solutions
Not applicable

Copying variables from an application to a second one

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.

10 Replies
afuchten
Valued Contributor

Copying variables from an application to a second one

Variables as in Script Variables??

Script you can open and copy pretty easily ...

Not applicable

Copying variables from an application to a second one

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.

Partner
Partner

Copying variables from an application to a second one

Great, thanks a lot Big Smile

Not applicable

Copying variables from an application to a second one

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
Valued Contributor

Re: Copying variables from an application to a second one

Gareth,

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

Thanks!

Not applicable

Re: Copying variables from an application to a second one

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
Valued Contributor

Re: Copying variables from an application to a second one

Thanks Paul!

jonbmorrison
New Contributor III

Re: Copying variables from an application to a second one

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

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)