topic Re: New data to override old data while storing old data in App Development

New data to override old data while storing old data

jp_afc — Thu, 13 Mar 2025 14:50:50 GMT

I have data that gets uploaded twice a month from an excel file with the same file name. The new data will completely override the new data but i will need to store the old data as I want to have a month by month comparison going as far back as possible.

I am seeing that I should use QVD files but I am not too sure how to go about it. Ive read the below information but im still not sure

Working with QVD files | Qlik Sense on Windows Help

Re: New data to override old data while storing old data

henrikalmen — Thu, 13 Mar 2025 17:18:56 GMT

Hopefully you have a field in the excel file that can work as index, for example a timestamp field. So you load your data from the excel file, and store it into a qvd file. Next time you first load the qvd file, and then you concatenate data from the excel file to the same table - but only data where the timestamp doesn't exist in the already loaded data (the data you loaded from qvd). Now that you have the old and the new data in the table in Qlik, you store the qvd again (overwriting the old one).

Re: New data to override old data while storing old data

amonjaras_c40 — Thu, 13 Mar 2025 22:47:21 GMT

Hello!

This help page will complement the one you mention regarding QVD files:

Loading new and updated records with incremental load

Hope it helps!