topic Dynamic update QVW with data from QVD in QlikView

Dynamic update QVW with data from QVD

Mon, 19 Oct 2015 17:15:31 GMT

Hello,

I have a very large QVW file that loads once a day. Since this is the most used QVW file in the company I want to put in it some data that refreshes hourly, data that doesn't mess with that data that loads once a day.

For the hourly data I've created a QVD file that reloads every hour. How do I add/update the data from the QVD into the QVW without reloading the entire file?

QVD - hourly

QVW - daily

Re: Dynamic update QVW with data from QVD

Anonymous — Mon, 19 Oct 2015 18:33:14 GMT

You could execute a partial reload if you don't want to have this automatically reload from the QMC

Here's a previous forum discussing it:

What is meant by partial reload? What is its use? Please explain!

Otherwise, use the QMC and set up a task where your QVW reloads off a successful completion of the QVD generator.

Re: Dynamic update QVW with data from QVD

Oleg_Troyansky — Mon, 19 Oct 2015 18:50:05 GMT

Partial reload is one option. Depending on your script logic, it may be more or less difficult to implement. However, the performance of partial reload can be flaky, and it's been frowned upon by R&D for quite some time.

A better alternative might be loading your "old" document using a Binary load (which is very fast, even for large documents) and then adding new data from the new QVD file. In order to enable this logic, your QVD file should be formatted exactly the same way as the Fact table inside your QVW. It means that no additional data modelling logic is necessary after loading the QVD. You will also need to ensure that the dimensional data is all there - meaning that you don't need to load new customers, new items, etc.. because of the new slice of data that you are adding hourly.

cheers,

Oleg Troyansky

Check out my new book QlikView Your Business: An expert guide to Business Discovery with QlikView and Qlik Sense