topic How To Easily Extract Qlik Sense Application Variables in App Development

How To Easily Extract Qlik Sense Application Variables

wdchristensen — Thu, 18 May 2017 19:21:52 GMT

I have an Qlik Sense application that has over 100 variables and I would like to extract the variable and their definitions to excel, csv or flat file without having to open up each variable and copy and paste for the rest of the afternoon. Any suggestions would be appreciated.

Re: How To Easily Extract Qlik Sense Application Variables

rwunderlich — Thu, 18 May 2017 20:46:51 GMT

Here's a semi-quick way.

1. Download and install the Backup & Restore extension GitHub - countnazgul/QS-backup-and-restore-app

2. Use the backup function to create a json file of the app.

3. Use a text editor to grab the names and values -- in the "variables" section at the end.

How do yo want to use the variables? To generate variables from script? I'd be interested in creating a tool.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Re: How To Easily Extract Qlik Sense Application Variables

wdchristensen — Fri, 19 May 2017 14:39:43 GMT

Hey Rob,

As always, your suggestion is exceedingly helpful! I am in the process of installing the application for testing. In addition to creating a variable list, your proposed solution would seem to have dozens of useful applications outside of just source control. For example, I could use this method as a global find and replace or if I want to see if my logic is consistent across various visualizations, I could just read the Jason instead of navigating all over the app. Prior to using variables, some of my apps contained logic like:

A > 5 and A < 10 // A is between 5 and 10; A could be a float…

A >= 6 and A < 10

A > 5 and A <=9

Finding and correcting these small inconsistencies is exceedingly time consuming and could be done much easier if I could see all the source code at one time.

To answer your original question, I have a large application (25+ pages) which contains all types of set analysis that will provide great examples for others on my team. The Qlik documentation is great for users who already know how to use it and just need a reminder on the basic syntax. However, it lacks use case examples so it is difficult to use as an independent resource. There seems to be a very limited number of qlik sense books, especially those written specifically for 3.0+. If you have the time to write a book, I am sure there would be a market for it!!! I really appreciate your help.

Re: How To Easily Extract Qlik Sense Application Variables

wdchristensen — Fri, 19 May 2017 15:56:16 GMT

For the sake of anyone else reading this thread, I was initially unable to load the zip file from:

https://github.com/countnazgul/QS-backup-and-restore-app

Perhaps because the original zip has another copy of the code zipped inside unzipped extract…

However, when I downloaded the most recent zip copy from the release page there no issue.

https://github.com/countnazgul/QS-backup-and-restore-app/releases

Re: How To Easily Extract Qlik Sense Application Variables

wdchristensen — Fri, 19 May 2017 21:18:22 GMT

I created the following document to assist others in the community with the same issue.

How to exact JSON data from Qlik Sense Application using SQL Server 2016

Re: How To Easily Extract Qlik Sense Application Variables

rwunderlich — Sun, 21 May 2017 21:07:56 GMT

Very nice idea using SQL!

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Re: How To Easily Extract Qlik Sense Application Variables

EliGohar — Fri, 15 Aug 2025 14:09:18 GMT

You can try Qollect - my free Qlik Sense extension that pulls app metadata (Measures, Dimensions, Fields, Charts, Variables, Sheets) and exports it to Excel.
Link: https://www.regarden.io/extensions/3170c06d-0cbb-462f-a3e6-5303f9763249