topic Limit load into QVD in QlikView https://community.qlik.com/t5/QlikView/Limit-load-into-QVD/m-p/646022#M236807 <HTML><HEAD></HEAD><BODY><P>How can I limit the number of weeks into a QVD? <SPAN style="font-size: 10pt; line-height: 1.5em;">For example, I have over 40 weeks of sales history data in a table but I only want to load the most recent 10 weeks of data. </SPAN></P><P></P><P>How can I do this? </P></BODY></HTML> Wed, 01 Oct 2014 21:22:41 GMT 2014-10-01T21:22:41Z Limit load into QVD https://community.qlik.com/t5/QlikView/Limit-load-into-QVD/m-p/646022#M236807 <HTML><HEAD></HEAD><BODY><P>How can I limit the number of weeks into a QVD? <SPAN style="font-size: 10pt; line-height: 1.5em;">For example, I have over 40 weeks of sales history data in a table but I only want to load the most recent 10 weeks of data. </SPAN></P><P></P><P>How can I do this? </P></BODY></HTML> Wed, 01 Oct 2014 21:22:41 GMT https://community.qlik.com/t5/QlikView/Limit-load-into-QVD/m-p/646022#M236807 2014-10-01T21:22:41Z Re: Limit load into QVD https://community.qlik.com/t5/QlikView/Limit-load-into-QVD/m-p/646023#M236808 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>you can filter weeks taking as reference you <STRONG>main date field:</STRONG></P><P></P><P></P><P>YOUR_TABLE:</P><P>LOAD *</P><P>from table.qvd(qvd)</P><P><STRONG>where week(Date) &gt; Week(today())-10 and Year(Date) = Year(today())</STRONG>;</P><P></P><P>so you'll get current week and the 9 before,</P><P></P><P>regards</P></BODY></HTML> Wed, 01 Oct 2014 21:45:46 GMT https://community.qlik.com/t5/QlikView/Limit-load-into-QVD/m-p/646023#M236808 jaimeaguilar 2014-10-01T21:45:46Z