topic Re: Incremental Load for Monthly Qvd in QlikView https://community.qlik.com/t5/QlikView/Incremental-Load-for-Monthly-Qvd/m-p/1233012#M392665 <HTML><HEAD></HEAD><BODY><P>I have done same task.</P><P></P><P>please go through the below thread</P><P><A href="https://community.qlik.com/thread/245686">Incremental load by using qvd date</A></P></BODY></HTML> Mon, 06 Mar 2017 07:58:29 GMT khalander 2017-03-06T07:58:29Z Incremental Load for Monthly Qvd https://community.qlik.com/t5/QlikView/Incremental-Load-for-Monthly-Qvd/m-p/1233010#M392663 <HTML><HEAD></HEAD><BODY><P>If my qvd are store on monthly basis i.e.&nbsp; test_201602 ,test_201709.</P><P>How we can apply the incremental load on this data</P></BODY></HTML> Mon, 06 Mar 2017 06:58:23 GMT https://community.qlik.com/t5/QlikView/Incremental-Load-for-Monthly-Qvd/m-p/1233010#M392663 Anonymous 2017-03-06T06:58:23Z Re: Incremental Load for Monthly Qvd https://community.qlik.com/t5/QlikView/Incremental-Load-for-Monthly-Qvd/m-p/1233011#M392664 <HTML><HEAD></HEAD><BODY><P>From your file format take date as</P><P></P><P>date(date#(right(Filename,len(Filename)-index(Filename,'_',1)),'YYYYMM')) as FileDate</P><P></P><P>If you have Incremental Script,</P><P>In your incremental script, use this Date from Previously stored Qvd, add 1 to it. Store it to the variable n then use that variable in Filename as test_$(vDate).qvd</P></BODY></HTML> Mon, 06 Mar 2017 07:54:35 GMT https://community.qlik.com/t5/QlikView/Incremental-Load-for-Monthly-Qvd/m-p/1233011#M392664 shraddha_g 2017-03-06T07:54:35Z Re: Incremental Load for Monthly Qvd https://community.qlik.com/t5/QlikView/Incremental-Load-for-Monthly-Qvd/m-p/1233012#M392665 <HTML><HEAD></HEAD><BODY><P>I have done same task.</P><P></P><P>please go through the below thread</P><P><A href="https://community.qlik.com/thread/245686">Incremental load by using qvd date</A></P></BODY></HTML> Mon, 06 Mar 2017 07:58:29 GMT https://community.qlik.com/t5/QlikView/Incremental-Load-for-Monthly-Qvd/m-p/1233012#M392665 khalander 2017-03-06T07:58:29Z