Reload QlikView Application (QVW) File Without Access To Data Source(s)
There could be occasions when you need to reload a QVW without having access to the source data. This can be done extracting the current data from an QVW into QVD files, and then use the QVD files as data source instead of the real data source.
Extract application data to QVDs
The attached QVW provides an easy and quick way to extract a data model to QVD file.
IMPORTANT: The source QVW must allow binary load, which is allowed in Document Properties > Opening > Prohibit Binary Load
Create a new folder
Save the attached ExtractDataModelToQvd.qvw to the folder created in step 1
Copy the QVW file that needs to be reloaded to a the folder created in step 1
Open ExtractDataModelToQvd.qvw in QlikView desktop client
Enter the filename copied in step 3 as the QVW file
Click "Extract QVD Files" button
The application will reload
Each table will now be stored to a separate QVD in the same folder as the QVW files reside
NOTE: The "QVW File" and "QVD Output Folder" can be defined to any valid path for
Reload customer application
Go to the folder created in step 1 in the above section
Open the QVW file that needs to be reloaded
Enter Script Editor (Ctrl + E)
Go to Edit > Clear Entire Script...
Select OK in the confirmation dialog
The script has now been reset to the default, by only containing the system format variables
Check the Relative Paths option in the Data from Files section in the script editor window
Click on Table Files... in the Data from Files section in the script editor window
Locate the folder where the QVDs from the section above where stored
Mark all QVD files and click Open
One file wizard window per QVD file will popup, click Finish on each of them
Load statements have been added for each QVD file in the script
Reload the application (Ctrl + R)
The QVW has now been reloaded without access to the original data sources
The original load script might include variables that need to be retained or restored in order to accomplish the original behavior of the application.