Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
datanibbler
Champion
Champion

What would be the best way of backing up qvw files?

Hi,

we have a company-wide QlikView structure (well, that is the plan...)

Of course, we need some way of saving backups of our qvw files.

The internal method is not a good option as these "Version_x_of_y" files tend to clutter up the working directory - I don't know a way of saving those automatically created copies somewhere else; Is there a way?

Until now, what we have been doing is simply copy the entire qvw file once a day to a designated backup directory - however, that takes up quite a lot of space, even if those backups are zipped or deleted after a while.

Is there a way to save space on that?

(for instance, I believe that in a qvw, there is always some working data alongside the code; Would there be a way of "emptying" a qvw before copying it to that backup folder?

Thanks a lot!

Best regards,

DataNibbler

1 Solution

Accepted Solutions
Brice-SACCUCCI
Employee
Employee

Hi Friedrich,

the QlikView application file, .QVW, contains the presentation layer (charts, tables, etc.), the script and all the data.

Usually, the data is the heaviest part.

If you want to shrink its size, you have several solutions like:

- Change the model to reduce the numer of columns, distinct values (unique keys and Link Tables are expensive)

- Change the compression level of the file: User Preferences > Preffered Save Format

- Remove the data: File > Reduce Data > Remove all values

But if you are in an Entreprise environnement, you probably have a QlikView Server.

You can add a variable which is tested at the beggining or your script and exits the script when set to 1, in order to have no data, like

If vExitScript = 1 Then

     EXIT SCRIPT;

EndIf

Then, in the server configuration, you could have a task loading the data with parameter vExitScript = 0, and another one loading the data with parameter vExitScript = 1, resulting in an application without data and that you could backup.

Regards,

Brice

View solution in original post

7 Replies
Brice-SACCUCCI
Employee
Employee

Hi Friedrich,

the QlikView application file, .QVW, contains the presentation layer (charts, tables, etc.), the script and all the data.

Usually, the data is the heaviest part.

If you want to shrink its size, you have several solutions like:

- Change the model to reduce the numer of columns, distinct values (unique keys and Link Tables are expensive)

- Change the compression level of the file: User Preferences > Preffered Save Format

- Remove the data: File > Reduce Data > Remove all values

But if you are in an Entreprise environnement, you probably have a QlikView Server.

You can add a variable which is tested at the beggining or your script and exits the script when set to 1, in order to have no data, like

If vExitScript = 1 Then

     EXIT SCRIPT;

EndIf

Then, in the server configuration, you could have a task loading the data with parameter vExitScript = 0, and another one loading the data with parameter vExitScript = 1, resulting in an application without data and that you could backup.

Regards,

Brice

marcus_sommer

You could use (extern) versioning-tools which could directly included in qv. But the handling won't be very easy in the beginning and it will cause additionally cost.

To copy all important apps is always a good idea. To save hd-space you could reduce the amount of data within the app, emptying isn't the best way because some data-structures could be destroyd (variables). I don't know if this could be done automatically.

Another possibility could be to read/export all data- and objects-structure in txt- and xml-files and restore apps on demand.

- Marcus

datanibbler
Champion
Champion
Author

Hi Brice,

yes, we have a QlikView server, but as up to now we do our Backups ourselves - we don't have a tested and proven Backup-routine in place yet, so we'd rather trust ourselves - so that menu-point

>>>    "Reduce data->Remove all values"

should do just fine.

I will try it out.

Thanks a lot!

Best regards,

DataNibbler

P.S.: Yep - that reduces the size of the file to backup by about half. Perfect!

Not applicable

Thanks Friedrich Hofmann & Brice Saccucci !!

Nice & informative post !!

nicolas_martin
Partner - Creator II
Partner - Creator II

loading the data with parameter vExitScript = 1


How do you load the data with a specific parameter in QEMC reload schedule?


Not applicable

Hi Nicolas,

Hope you are doing good.

Did you find any work around how to do this from QMC or by any script ?

Regards,

Jaydeep

nicolas_martin
Partner - Creator II
Partner - Creator II

No, I didn't...