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

[#1]

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

Thanks in advance,

Vinia

[Gysbert_Wassenaar]

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.

[#3]

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

[Gysbert_Wassenaar · Accepted solution]

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.

[#5]

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

[Anonymous]

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!

[dyy]

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

[deepti_singh]

Hi Dyy,

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

[rwunderlich]

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

[vrushalip]

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