https://community.qlik.com/t5/App-Development/Splitting-the-QVD/m-p/2517309#M105906 <P>Maybe :</P><P><EM><STRONG>If(WeekDay(Today())='Sat' Then</STRONG></EM></P> Fri, 09 May 2025 12:33:59 GMT dmac1971 2025-05-09T12:33:59Z https://community.qlik.com/t5/App-Development/Splitting-the-QVD/m-p/2517304#M105904 <P>I have a Sales table where I load data since 2021. but I am trying to split this and running the full load on Saturdays. Other days will run only<BR />the current year data and concat with the previous one. Below is the one I am looking for. Please let me know if this makes sense.</P><P>QVD 1</P><P>IF (Saturday run the below)</P><P>Select * from Sales<BR />where sales_date &lt; sysdate - 365</P><P>store into QVD</P><P>Main QVD</P><P>QVD 1</P><P>Concat</P><P>Select * from Sales<BR />where sales_date &gt;= sysdate - 365</P> Fri, 09 May 2025 12:15:44 GMT https://community.qlik.com/t5/App-Development/Splitting-the-QVD/m-p/2517304#M105904 jjustingkm 2025-05-09T12:15:44Z https://community.qlik.com/t5/App-Development/Splitting-the-QVD/m-p/2517309#M105906 <P>Maybe :</P><P><EM><STRONG>If(WeekDay(Today())='Sat' Then</STRONG></EM></P> Fri, 09 May 2025 12:33:59 GMT https://community.qlik.com/t5/App-Development/Splitting-the-QVD/m-p/2517309#M105906 dmac1971 2025-05-09T12:33:59Z