Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
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.

View solution in original post

11 Replies
Highlighted
Specialist
Specialist

Copying variables from an application to a second one

Variables as in Script Variables??

Script you can open and copy pretty easily ...

Highlighted
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.

View solution in original post

Highlighted
Partner
Partner

Copying variables from an application to a second one

Great, thanks a lot Big Smile

Highlighted
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

Highlighted
Specialist
Specialist

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!

Highlighted
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!

Highlighted
Specialist
Specialist

Re: Copying variables from an application to a second one

Thanks Paul!

Highlighted
Contributor III
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

Highlighted

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)