Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
Showing results for 
Search instead for 
Did you mean: 
Creator III
Creator III


Hi All

I have stored the last 100 days data in a Qvd

now I have built a qvw that will load that data and be scheduled to run everyday and collect the previous days data "sysdate-1"

essentially what I would like to do is only update the current data with the previous days data every day

running that today would be fine I would have the last 100 days of data and yesterdays data, but if I had to reload tomorrow I would lose yesterdays data in tomorrows model. I understand I could store the "sysdate-1" data into a qvd as well but when reloading it the qvd will also be overwritten, how could I store the "sysdate-1" data into the qvd everyday without overwriting the previous days data?