Attached Sales Analysis - QVF file , I have generated from Qlik Cloud - Demo App . Now I am looking forward for the real data set for adding some changes and re-load it with more graphics. Not sure how to get actual data set in .csv format for this app or even any other demo app with dataset e.g. Financial Analysis or Supply Chain Analysis.
If you don't have the original files, maybe you can create a new application and perform a binary load from the original app (for instance, the Financial Analysis App). Then, create a for statement to loop through all tables of the data model and store them as CSV files. This code should do the trick (just change the appId and the folderPath):
Binary lib://QlikSenseApps/<appId>;
// 1. Define the target folder connection where the CSVs will be saved.
LET vExportPath = '<folderPath>';
// 2. Get the total number of tables currently in the data model.
LET vTableCount = NoOfTables();
// Output the total number of tables found
TRACE Found $(vTableCount) tables to export.;
// 3. Loop through all tables (index starts at 0).
FOR i = 0 TO $(vTableCount) - 1
// 4. Get the table name
LET vTableName = TableName($(i));
TRACE ----------------------------------------------------;
TRACE Exporting table: $(vTableName);
// 5. Store the table as a CSV file.
STORE [$(vTableName)] INTO '$(vExportPath)$(vTableName).csv' (txt, delimiter is ',');
TRACE Stored successfully: '$(vExportPath)$(vTableName).csv';
NEXT i
