Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to update excel values using incremental load

I'm using excel data as input into my qv application using incremental load. If I change any cell value in excel then how to update the value in QVD file.

EX:

Date 1Sales 2
6/4/2018500
6/5/2018100
6/6/2018300
6/7/2018700

If I change any cell value in sales column how to update in qvd file

4 Replies
qlikwiz123
Creator III
Creator III

Hi,

You have to re-run the Incremental Script every time you want to update the QVD. In case of a server, you can schedule the QVW to refresh on a schedule so that it pulls the updated values from the Excel and stores them into QVD.

Anonymous
Not applicable
Author

Hi,

Thank you for your reply. I can able to load new or updated records into qvd using incremental load. But If I modify any cell value (Ex: in sales column in above table ). How to update the modified value in our existing qvd.

ravikumar89
Contributor II
Contributor II

Hi

Just reload the Document.It will fetch the updated values and stores into QVD.

agomes1971
Specialist II
Specialist II