topic Re: Update dates automatically in QlikView

Update dates automatically

bharatkishore — Fri, 31 May 2013 10:26:21 GMT

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

Re: Update dates automatically

Gysbert_Wassenaar — Fri, 31 May 2013 10:30:38 GMT

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

Re: Update dates automatically

bharatkishore — Fri, 31 May 2013 10:55:11 GMT

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.

Re: Update dates automatically

er_mohit — Fri, 31 May 2013 10:59:19 GMT

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

Re: Update dates automatically

bharatkishore — Fri, 31 May 2013 11:01:21 GMT

There is no video attached mohit.