Overwriting old qvd with new one on the basis of date Qliksense

[Aspiring_Developer]

Hello All,

I have below data :-

I am storing this data into qvd and my data is refreshed everyday and it comes from the SQL data source.

Now , my requirement is to implement below logic:-

--Data for 15-jun-22 is refreshed and stored in qvd.

--next day , when the data for 16 0jun-22 is reloaded, I need to place a condition which will check if this new data comprises the data for the date 16-jun-2022. If yes, it should overwrite the old qvd, if not , it should not overwrite and the data should not be changed in my old qvd created for 15-jun-2022.

I am not sure how to do it, I think I have to use max date to apply this condition but not sure how it will be done.

Can anyone please help me ? 

Thanks in advance

@sunny_talwar 

[Vishal_Gupta]

Did you try implementing an incremental reload?

This seems to be a simple use case of incremental load.

Below link should help you

1.

https://help.qlik.com/en-US/sense/May2022/Subsystems/Hub/Content/Sense_Hub/LoadData/use-QVD-files-in...

[Aspiring_Developer]

That might not work because when the new data comes in , the old data values are completely changed.

I am assuming we can try something like applying condition like if date of qvd is greater than today then the data should be overwritten else not .

 Not sure if i am clear enough.

thanks