topic Keep data in QlikView

Keep data

Thu, 29 Sep 2011 13:37:14 GMT

I have an sql, which takes data only for the actual date. I would like to run it everyday keeping the datas of the days before. How can i do it?

Keep data

SunilChauhan — Thu, 29 Sep 2011 13:59:23 GMT

would you like to store data of 1 day back

Keep data

Thu, 29 Sep 2011 14:04:06 GMT

Actually i would like to store all the past data.

Re: Keep data

Sokkorn — Thu, 29 Sep 2011 14:04:46 GMT

Hi,

Try to use Incremental Load that this one can keep your historical data.

Regards,

Sokkorn

Re: Keep data

Thu, 29 Sep 2011 14:06:23 GMT

How does it work?

Thanks,

Javier

Re: Keep data

its_anandrjs — Thu, 29 Sep 2011 14:09:16 GMT

Hi,

Use some thing in your load script.

Load Incremental( StartDate - Enddate,'DD')

Rgds

Anand

Re: Keep data

SunilChauhan — Thu, 29 Sep 2011 14:10:50 GMT

see the attached pdf

hope this heelps

Re: Keep data

its_anandrjs — Thu, 29 Sep 2011 14:20:25 GMT

Hi,

Follow this link

http://community.qlik.com/docs/DOC-1870

It is a best practice

Rgds

Anand

Re: Keep data

Sokkorn — Thu, 29 Sep 2011 14:24:05 GMT

Hi Javier,

In the community have a lot of incremental load example. The purpose of incremental load is keep historical data. This one can be call Data Warehouse. The question is How does it work?

Load full for the first time (Ex. from 01.09.2011 to 29.09.2011) then store into QVD file.

After that the new data in 30.09.2011 come, then we load new data only for the date 30.09.2011 and concatenate with the previouse data.

Regards,

Sokkorn

Re: Keep data

Thu, 29 Sep 2011 14:30:18 GMT

But the data i want to keep are the ones which are showed in QLikview, i don't generate any table. The problem is my sql only takes the data for the actual date and i want to add them. I see all your helps are for taking only the actual data of some table.