topic Re: Updating QlikView from Datasource"Excel" in QlikView

Updating QlikView from Datasource"Excel"

Sat, 19 Apr 2014 08:39:45 GMT

Hello,

My excel workbook which is updated daily is my datasource uploaded to Qlikview.

Question: Is there a way that once the excel is updated that its reflected in QlikView without re-uploading the excel file so I won't have to rewriting script editing to display as I would like.

Thank you

Re: Updating QlikView from Datasource"Excel"

swuehl — Sat, 19 Apr 2014 08:44:55 GMT

I am not sure what you want to achieve.

If you want to trigger the reload on the server from externally, you can use EDX

Using EDX in QlikView 11

You can also create a time schedule on the server that may fit your needs, e.g. reload every hour.

I think in any scenario, you would need to somehow trigger a reload of your document.

Re: Updating QlikView from Datasource"Excel"

tresB — Sat, 19 Apr 2014 08:48:12 GMT

Filetime() function tells the last modification time of a file. But this is a script function. You can use this function in the script before LOAD statement and decide if the file is to be reloaded or not(use exit script command to skip the reload).

Re: Updating QlikView from Datasource"Excel"

Miguel_Angel_Baeyens — Sat, 19 Apr 2014 09:04:07 GMT

You could be reloading the file every 5 secs or the time your load needs, but I rather use an EDX trigger as mentioned above or an scheduled reload. Anyway, QlikView needs to reload the script and therefore reading the data sources, you cannot push into memory what you have just changed in Excel.

If you are using QlikView Server, you can check about the Real Time Server functionality in the following links just in case it works for you:

Real Time Server
QlikView Real Time Update (Old version, but interesting discussion anyway)
How to use Dynamic update action in QV 11

Miguel