Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 1 | Sales 2 |
---|---|
6/4/2018 | 500 |
6/5/2018 | 100 |
6/6/2018 | 300 |
6/7/2018 | 700 |
If I change any cell value in sales column how to update in qvd file
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.
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.
Hi
Just reload the Document.It will fetch the updated values and stores into QVD.
Hi,
please read this:
https://www.analyticsvidhya.com/blog/2014/09/qlikview-incremental-load/
HTH
André Gomes