topic Re: How do I export variables created using the QlikSense variables interface? in App Development

How do I export variables created using the QlikSense variables interface?

Sat, 12 Mar 2016 14:46:18 GMT

Is there a way to print or export the variables I created in QlikSense?

Thanks in advance,

Vinia

Re: How do I export variables created using the QlikSense variables interface?

Gysbert_Wassenaar — Sun, 13 Mar 2016 17:40:21 GMT

I suppose you could create a text object that lists all the variables and their values.

But instead of creating the variables you can create an excel file with variables, values, comments etc. and load that excel file in the script and create the variables in the script as well from the excel file. Or you could create an include file and define all the variables in that script file. That makes it a lot easier to maintain the variables and optionally reuse them in other apps.

Re: How do I export variables created using the QlikSense variables interface?

Mon, 14 Mar 2016 06:04:04 GMT

Thank you for your reply, Gysbert. How exactly do I "create a text object that lists all the variables and their values"? Sorry if my question's not clear. I am referring to these variables I created through the variables interface on Qlik Sense.: (please see image).

I need a text file of it for the documentation of the app. It would be very tedious to copy-paste each variable. Is there a way to export the names and definitions to a file one time?

Thanks again,

Vinia

Re: How do I export variables created using the QlikSense variables interface?

Gysbert_Wassenaar — Mon, 14 Mar 2016 08:02:15 GMT

Perhaps you can use this extension: Backup and Restore App‌. For future apps I advice to create your variables in an external file and load/create the variables from that file.

Re: How do I export variables created using the QlikSense variables interface?

Wed, 16 Mar 2016 04:51:38 GMT

Thank you, Gysbert. Was able to copy my variables from the json file. Thank you for suggesting the use of the Backup and Restore App. That did the trick.

Many thanks again!

Cheers,

Vinia

Re: How do I export variables created using the QlikSense variables interface?

Anonymous — Mon, 29 Aug 2016 17:56:42 GMT

Hi Vinia,

How could you able to copy Variables from Json file? I could see them in Notepad++, but How did you copy to excel/ external file?

Thanks in Advance!

Re: How do I export variables created using the QlikSense variables interface?

dyy — Thu, 17 Aug 2017 16:31:34 GMT

any way to get a list of variables with the objects they are used in from Sense app? I am trying to find out what variables are not used in the application

Re: How do I export variables created using the QlikSense variables interface?

deepti_singh — Wed, 29 May 2019 18:25:11 GMT

Hi Dyy,

I have the same question. Did you find out how it can be done?

Re: How do I export variables created using the QlikSense variables interface?

rwunderlich — Wed, 29 May 2019 19:11:34 GMT

You can use QS Document Analyzer http://qlikviewcookbook.com/recipes/download-info/qs-document-analyzer/ to list the variables and identify where/if they are used in the application.

If you just want to export all variables in an application, you can use the devtool extension https://github.com/erikwett/DevTool

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

Re: How do I export variables created using the QlikSense variables interface?

vrushalip — Wed, 05 Feb 2020 06:59:13 GMT

Hi Vinia,

I found one solution that might help you.Try using the extension ''Qlik Sense Variable Editor Mashup'' .

For the steps to include the extension in qlik sense, once included Navigate to Dev-Hub and locate the mashup (should appear as "Variable Editor"). Right click on it > View, and that should open the mashup using the virtual proxy you are using already.

The above extension works better in chrome browser.

Thanks,

Vrushali

Re: How do I export variables created using the QlikSense variables interface?

vaibhavb — Wed, 05 Feb 2020 07:20:11 GMT

Hi Vrushali,

I followed the steps and found your answer very useful. Thanks a lot.

Thanks and Regards,

Vaibhav Bhurke.