topic auto script reload on data change in QlikView

auto script reload on data change

Thu, 08 Dec 2011 12:01:21 GMT

Hi,

I have a .qvw file which i have deployed on qlikview server and now running it through a URL.I want to reload script of this .qvw file automatically whenever data file(which is .xml file) gets any data modification.Is this possible to achieve this thing in qlikview.Kindly help.

Regards

Richa

auto script reload on data change

Thu, 08 Dec 2011 13:03:30 GMT

Hi Richa,

You need to schedule a reload task in QlikView server depending on the frequency of data change you expect.

Regards,

Sajeevan

auto script reload on data change

Thu, 08 Dec 2011 15:00:10 GMT

Hello,

If you are looking to do some real time reporting, then you need to consider a lot of things, like the size of the application and the data model etc. Can I ask you what do you mean by data modification? How is that being handled now and what are you trying to achieve?

QV is the wrong tool for complete real time reporting solutions, but you can get to near real time reporting.

Thanks

auto script reload on data change

flipside — Thu, 08 Dec 2011 15:44:48 GMT

Hi Richa,

A solution could be to ...

1) Schedule a separate QVW to run every minute to look for the new file and if the date of the file has changed get the load script to do something you know will fail.

2) Schedule your actual QVW to reload dependant only on the first job failing.

I have a few jobs scheduled this way. Of course if your file takes a while to reload, it might not be the best solution, but the file won't reload when it doesn't need to.

flipside