I'm new in QVCommunity and hope you can help me with the following issue:
I have created the QlivView with the Year to Date data
and there is *.txt source file with automatic update for last 10 days.
Each time I do reload, the old data removed and i've got only new one's.
Is it possible somehow to store the old data in Qlikview and just add the newest one?
Cuz it's tricky to do the YTD extraction each week for instance and do yearly reload.
Thank you in advance for any ideas you may have.
You should make use of QV's .qvd files for this. Something like:
Perform an initial load -
STORE Data INTO Data.qvd;
Then, each time you want to load new data perform an incremental load -
STORE Data INTO Data.qvd
This will append the new data to the old each time.
Hope this helps,
View solution in original post
Thanks Jason, it helps a lot.