Is there any way to extract data from QlikView document to QVD or CSV?
Environment:
QlikView
QlikView Governance Dashboard
Resolution:
Here is an easy approach to extracting the data model from a QlikView (QVW) file. The example documented uses QlikView Desktop, if you are using Qlik Sense then please click here.
Why would you use or need this kind of technique?
In a production environment, you may find the use of the output table script elements without the variables as they can be useful in load processes when transformed QVDs can be re-used by other applications. However, there are many times where you need to create something quickly for an ad-hoc piece of work or as a demonstration to show a customer with amended data to make it more relevant (changing product, department names etc). This approach can also be useful when working offline on the front end or application tuning where you do not want to deal with all of the complications of the ETL process.
Step 1 - Enter the file name and path for the QVW from which you wish to extract data
- Enter the full file path and name for the QVW
- e.g. C:\Demo\Application\Executive Dashboard.qvw
Step 2 - Enter the destination folder path where the extract data will be saved
- Enter the full folder path for the destination folder
- e.g. C:\Demo\Export Data
Step 3 - Select the output format type
- Your choices are either QVD (Qlik's proprietary file store format) or more generic CSV
Step 4 - Save and reload the application
Please note these instructions are also included in the dashboard itself in case you forget where it came from. This is what the dashboard looks like.