topic Qvds in QlikView https://community.qlik.com/t5/QlikView/Qvds/m-p/524779#M196061 <HTML><HEAD></HEAD><BODY><P>Hi All</P><P></P><P>I have stored the last 100 days data in a Qvd</P><P>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"</P><P>essentially what I would like to do is only update the current data with the previous days data every day</P><P>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?</P><P></P><P>Thanks</P></BODY></HTML> Fri, 25 Oct 2013 06:56:43 GMT rido1421 2013-10-25T06:56:43Z Qvds https://community.qlik.com/t5/QlikView/Qvds/m-p/524779#M196061 <HTML><HEAD></HEAD><BODY><P>Hi All</P><P></P><P>I have stored the last 100 days data in a Qvd</P><P>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"</P><P>essentially what I would like to do is only update the current data with the previous days data every day</P><P>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?</P><P></P><P>Thanks</P></BODY></HTML> Fri, 25 Oct 2013 06:56:43 GMT https://community.qlik.com/t5/QlikView/Qvds/m-p/524779#M196061 rido1421 2013-10-25T06:56:43Z