topic Auto update web files in QlikView

Auto update web files

jeanique — Wed, 25 Nov 2020 16:16:04 GMT

Hi all

I have created a Qlikview document that shows the exchange rate per country. I have added this as a web file in the script and I need to update this without having to run the script every time. Is there anyone who could assist me in maybe using incremental load to update a web file? (P.S. This is the website I am using www.xe.com/currencytables/?from=ZAR)

Thank you

Re: Auto update web files

jonathandienst — Tue, 05 Apr 2016 16:06:41 GMT

I suggest that you upload a sample of your qvw document with some representative data to allow more relevant and specific assistance. There is a wealth of information on how to use incremental loads.

But I am not sure that it is really necessary for exchange rate files which will usually be quite small extracts - unless the rates in that web site are spot values for the current day only and you would like to build up a history.

Re: Auto update web files

Gysbert_Wassenaar — Tue, 05 Apr 2016 16:07:17 GMT

An incremental load will still need an execution of the script. So will a partial reload. I don't think you can get around that unless you want to mess around with Dynamic Update. But you could look into a partial reload and use a Replace Load to replace only the data in the currency table.