Qlik Community

Ask a Question

QlikView Administration

Discussion Board for collaboration on QlikView Management.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
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
baa
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
baa
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

marcus_sommer
MVP & Luminary
MVP & Luminary

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
Partner

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
Partner

No, I didn't...