Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Store into QVD

Hi,

If and storing a excel into QVD, how do I store only information added from today to the QVD except updating old data??

currently am using below code. Thanks in advance..

STORE PLANNING into <PATH> <FILE NAME.qvd>;

5 Replies
alkesh_sharma
Creator III
Creator III

you have to create incremental load script first.

amit_saini
Master III
Master III

Mafaz,

For doing this we are using Incremental load , check below:

Incremental Load.

Re: Is it possible to refresh qvd's daily

Thanks,
AS

ashfaq_haseeb

Hi,

Check this

Incremental Load Script

Regards

ASHFAQ

TigerisBack
Champion
Champion

X:

Load qvd you have generated

then Concatenate

Load *

from excel where Dateavialble=Today()

store X into X.qvd

--------------------> append todays date and overite qvd's

Not applicable

when its come to incremental load if I update something it also get changed but what I really what is

I got an excel sheet as below where every month huge set of records get updated so I don't wan't to load old data

Case:- If am in the month of DEC I want to load only the month of DEC, since data up to NOV in the .qvd

I don't want to overwrite, I just want to write only newly added record and If some one do any changes to the old data It should be not loaded from excel.

only >= max to month in excel should be loaded when am initially loading excel.

HOW TO DO IT?...

MonthCompanyDepartmentFactoryBuyer
Apr-13AAdmin1Diesel, Hugo Boss
May-13AAdmin1Diesel, Hugo Boss
Jun-12BMerchant2Hugo Boss
Jul-12CProduction2Diesel, Hugo Boss
Jul-12DFinance 1Diesel
Jul-14DFinance 1Diesel