Qlik Community

QlikView Documents

Documents for QlikView related information.

Saving .qvw versions quickly

Not applicable

Saving .qvw versions quickly

Hi folks, This is just a reminder for the majority of folks but may be of some assistance to others, especially the newbies. When working with large data sets, use of the Debug functionality to test 000’s of rows before working with 000,000’s++ rows is essential.  However, even when working with 00,000’s of rows, QV scripts can end lead to lot of data being pulled into ram from your working script.  Regular saving of the .qvw is essential but this can be time consuming when QlikView has to save all the post-script execution working data.  To instantly save just the .qvw without all this data, go to the Debug functionality and then hit Close straightaway.  This removes all resident data so that you can save the current .qvw with no delay.  A word of caution, hitting the Cancel button will close without warning and you could lose all of your most recent changes.  Making use of this method will allow you to create development versions of your .qvw’s in a convenient manner. Regards, Alex

Tags (1)
Labels (2)
Comments

You can always use the File, Reduce Data option and Remove All Values to clear all data.

Or install an SSD drive :-)

jaaldurgam
Valued Contributor

Well Said Colin!.. Its always risky to go with closing the debug window abruptly!

Not applicable


Thanks Colin, I hadn't discovered that one and having just tried doing reducing the data, I have to agree, it works great.  The only discernible differences seem to be that the reduce data option forces a Save As when saving instead of hitting the blue disk and automatically overwriting the old version.  And the file size remains marginally larger using reduce data.

Either way, given my experience working with debug, I would agree that using reduce data is less risky and just as quick.

Version history
Revision #:
1 of 1
Last update:
‎10-22-2015 04:18 AM
Updated by: