Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm new to QlikView, and now doing some research trying out QV Personal Edition 9 (SR5).
Would appreciate if anyone can give me an idea on how to load data from an excel file with new data every month into a history datastore in QlikView, such that we can use the history datastore for reporting purposes.
Thank you.
Lindy,
Go to the Help within QlikView and search for "Using QVD files for incremental load". This is probably the best way to achieve the result you're looking for!
AllData:
Load
*
From New_Data.qvd
concatenate
Load
*
From Old_Data.qvd
where(Primary_key_New_Data Not Exist Primary_key_Old_data);
Store AllData into c:\AllData.qvd;