topic Re: Reload (& refresh?) an open document in personal edition in QlikView

Reload (& refresh?) an open document in personal edition

Fri, 10 Jan 2014 13:25:25 GMT

Hello

Very new to Qlikview, and currently trailing the personal edition. I need to reload a document automatically every 5 minutes. I have managed to get this to work by windows scheduler as mentioned in various posts on this site.

How-ever if the document is open, the reload doesn’t seem to take effect until you close & re-open the document. I have clarified that the reload is working, (because if you close and re-open the document the data is updated with the new info), it is as if the document doesn’t refresh.

Please point me in the right direction!

Re: Reload (& refresh?) an open document in personal edition

Colin-Albert — Fri, 10 Jan 2014 13:33:49 GMT

QlikView server pushes reloads to users. You are using a desktop version so clicking reload in the document is the way to refresh the data. The batch file will refresh and save an updated file, you must open this file to get the updated data, if the file is open then you may get locking issues.

Re: Reload (& refresh?) an open document in personal edition

jonathandienst — Fri, 10 Jan 2014 13:37:59 GMT

Qlikview desktop operates entirely in-memory and is not connected in any way to the disk file. So when you refresh the model in a separate QV process, the disk file is updated and the desktop client has no way to retrieve the updated information unless you close and re-open the document as you are doing.

Background refresh is possible with QV server, but not with the desktop.

HTH

Jonathan

Re: Reload (& refresh?) an open document in personal edition

Fri, 10 Jan 2014 13:38:11 GMT

Thanks Colin

So is it not possible reload the document automatically, say every 5 minutes when using a desktop/ personal version?

I wanted to avoid having to click reload everytime!

Re: Reload (& refresh?) an open document in personal edition

Colin-Albert — Fri, 10 Jan 2014 13:39:30 GMT

You will need QV Server to have the reload pushed to the users automatically.

Re: Reload (& refresh?) an open document in personal edition

Mon, 13 Jan 2014 15:31:39 GMT

Thanks All,

Not the answer I was hoping for but I understand.

I created a work-around, using dynamic changing sheets ( they loop around), and a macro that triggers on sheet activate which reloads the document, and this seems to work fine.