Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
wdchristensen
Specialist
Specialist

How To Easily Extract Qlik Sense Application Variables

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.

5 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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

wdchristensen
Specialist
Specialist
Author

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.

wdchristensen
Specialist
Specialist
Author

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

wdchristensen
Specialist
Specialist
Author

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

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP