Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

How to do an update query

Hello

I have a piece of SQL which loads in data for the last year from Today's date.  I schedule this information to run once a week

However, what I really want it to do one load of the SQL where I can date it back to 2010

and then once a week,  my schedule SQL will run and update the original load (which dates back to 2010) but just refreshes the last year

Can anyone let me know that initial steps I need to take (I  think I know the first 3 stpes)

I.e.

1) Load data back to 2010

2)Store data for 2010 (In a QVD?)

3) schedule SQL to run weekly

4) ??

Any help or advice will be greatly appreciated

Thanks

Helen


1 Reply
Highlighted
Specialist
Specialist

Re: How to do an update query

Hi,

you can do incremental data

see:

http://community.qlik.com/thread/53555

or here

http://community.qlik.com/thread/45573

hope this will help you.

Ariel