Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Variables as in Script Variables??
Script you can open and copy pretty easily ...
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.
Great, thanks a lot
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
Gareth,
Did you ever find a way to copy both the variable name and it's value between applications?
Thanks!
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!
Thanks Paul!
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
Here, how it is possible to copy one file object to another file