Store the Data in a daily basis

[#1]

Dear Guru's

As I need to store the value on daily basis, the Qvw will reload daily in the scheduler

Using the script for today I can store the value's in a qvd for today  but I would like to append the values for next day and so on.

Any idea. Please..

SQL SELECT

Curdate() as Tdate,

Product_Code,

Product Name,

Count(Invoice) as Inv,

Sum(Rupee) as Rup

FROM Salesdata

Group By Product_Code,Product_Name;

Store Trend into Test.qvd;

Regards

Joe

[#2]

Use Rob Wunderlich's QlikView Cookbook. This has an example which clearly  explains the incremental load.

[#3]

Dear Haneesh,

Thanks a lot, it works...

Regards

Joe