CODEWITHSUNDEEP
qliksense
Keith
Keith

Reputation: 154

How to export all data from Qlik Sense Desktop app

I’m new to Qlik Sense so, apologies if I’m missing anything that’s painfully obvious.

I downloaded an app that someone at my company created.

My problem is that I want to use that app as a template and update field names and create new visualizations for a demo and I don’t have access to the original data source (the app is no longer actively importing that and I have no idea where that data lives).

When I go to the Data tab there’s a warning that says “Data load failed. Resolve the problems and refresh the data.”

That said, even without the connection, all of the visualizations still work and are interactive so, the data must be in there somewhere(?).

I know it’s possible to export data from a specific visualization by right-clicking it, that’s not what I mean.

I’m looking to get all source data for the entire app. Also, I’m not picky when it comes to format. Multiple CSVs, excel with multiple tabs, sent to external SQL database are all valid options.

Upvotes: 0

Views: 3086

Answers (1)

Stefan Stoychev
Stefan Stoychev

Reputation: 5012

Qlik Sense (and View) have something called Binary Load. This type of load is loading the data from another qvf file.

So in your case:

  • create a data (folder) connection to the folder where the source qvf file is located
  • create new empty app
  • open the script editor
  • at the top of the script (row 1) type: Binary lib://MyDataConnection/MyDataFile.qvf;
  • Save and reload

(If the qvf file is already in the QS Apps folder then you can simply use: Binary MyDataFile.qvf;)

Once the reload is complete your new app will have the same data as the source file (not the same script ... just the data - tables, fields, values)

And at this point you can start manipulating the existing tables/fields (or create new), create visual objects etc.

If you still want to export all the tables you can use the following script to loop through all the tables and export them into qvd (for example)

for i = 0 to NoOfTables() - 1

  let tableName = TableName($(i));

  Store [$(tableName)] into lib://MyDataConnection\Path\to\some\folder\$(tableName).qvd;
next

Upvotes: 1

Related Questions