Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Member,
I have created a variable to get data from one year. Like
Let testgroup=date(MAKEDATE(2012,04,01),'DD-MMM-YYYY');
Now i am loading table like below.
FM_BOOKING_DET_NEW:
SQL SELECT *
FROM ADDB."FM_BOOKING_DET"
WHERE "AIR_DATE" >=to_date('$(testgroup)') ;
Now my question is everyday the data is fetching from 2012 to till date and its taking a lot of time to get reload. Now i need it should fetch data from 2013-06-01 and every day it should go on incremental process. Can anyone help me on this.
Thanks and Regards,
RBK
See this discussion. I recommend you use Qlikview Components to easily set up incremental reloading. See Rob Wunderlich's blog post for more information.
Thanks a lot for your reply. I am using QV 8.5V. Is there any way to do this like by giving conditions like
= Date(AddMonths(Today(),-1),'DD-MMM-YYYY')
IF there is any way please help me on this.
See the attached video
Edited :--Mohit
Sorry for some reason i can't upload that video but
go to this link might have helful for you
Go to attached link
http://www.learnqlickview.com/incremental-data-load-in-qlikview/
hope it helps you
There is no video attached mohit.