Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

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: 
Not applicable

update of the QVD files

Hello All,

I have a question about the update of the QVD files :

here is the current process which is done automatically :

1/ qlikview connect to the datebase and read the data of D-1 (data from the previous day) in a table (rejects)

2/ save the data in the QVD files with the name "rejects_D-1"

  example : today  (08/09/2016) qlikview read the data of  08/08/2016

                    these data will be saved in the qvd ->"rejects_20160808"

3/ load the qvd files to construct the KPIs.

My problem is : sometimes one field (which called "status") change in the database.

Example : if in 1 week, the data of 08/08/2016 change  in the database , i must change the qvd "rejects_20160808"


is there a way to change also the qvd file ? if it is possible could you help me to do this.

Thank you in advance for your help

regards

3 Replies
adamdavi3s
Master
Master

Hi,

Do you have something to tell you when that field has been updated? e.g. updated flag / date?

If so then you can do an incremental load which is loading the QVD, loading any changes and then re-saving the QVD

Have a read here:

http://www.quickintelligence.co.uk/qlikview-incremental-load/

Not applicable
Author

Hi Adam,

thank you for your answer

Yes if the field is changed the field "date" is updated

regards

adamdavi3s
Master
Master

Ok in that case then you should be able to do an incremental load, you will need a key field for this

The logic will depend on your situation of course but I imagine it will go something like:

1- check date updated and load in changed rows from SQL

2- Reload the relevant QVD using a not exists load to only load the rows which haven't changed and concatenante this to the existing data

3- Re-save the data in to the original QVD

The link I provided will hopefully help you work through it.