Update dates automatically

[bharatkishore]

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

[Gysbert_Wassenaar]

See this discussion. I recommend you use Qlikview Components to easily set up incremental reloading. See Rob Wunderlich's blog post for more information.

[bharatkishore]

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.

[er_mohit]

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

[bharatkishore]

There is no video attached mohit.