Auto Reload in script

[#1]

Hi Guys

Hope someone can help,

I'm looking to write a code into the script that will reload the data every hour - Isthat possible ?

Thanks

Anne

[matt_crowther]

There are several options:

1. Use a batch file / Command Line controlled by Windows Scheduler every hour.

2. For an all internal Qlikview method I've used a timed switch between 2 sheets ie: if the time is anything other than on the hour exactly Sheet A displays but for the second of on the hour Sheet B appears and there's a reload Action launched by an OnActivate Sheet Trigger. I've used this for QV docs published via a live PowerPoint link on information screens - cycle through tabs every 30 seconds and after each cycle do a silent reload to keep the data 'Live'.

3. Of course there's also the server option.

Hope that helps,

Matt - Visual Analytics Ltd

[kaushiknsolanki]

Hi,

    If you are using the QlikView Server, you can create a task and schedule it to run every hour.

Regards,

Kaushik Solanki

[#4]

Hi Matt,

Thanks for your response, I am brand new at this !!!

I have a Qlikview doc that has 5 sheets , its loaded in only from Excel files ( we are new to Qlikview and are waiting to get database access!!)

Basically, we would like as live a feed as possible onto the Qlikview dashboard , presently every hour or so I am ( as the main administrator!!!) literally just pressing the Reload Icon to refresh the data. I'd like to avoid having to do that !!!

Can you give me some more informationas to how I can maybe apply any of your options above ?

Thanks

Anne

[#5]

Hi Kaushik,

We are not on the server yet as we only have sample licenses ( Currently the only built Dashboard is available on my Hard drive !!!!!) , we are in the process of purchasing full licenses.

So is it only possible to do this if on the server ?

Thanks

Anne

[montubhardwaj]

The better option will be to create a batch file and trigger using windows scheduler.

[matt_crowther]

As Sharma says the best option of the 3 (seeing as you don't have a server yet) is to create a batch file.

All the batch file needs to contain is the following:

"C:\Programs\Qlikview\QV.exe" /r "C:\MyDocs\MyQlikviewDoc.qvw"

The first part is the location of your Qlikview .exe file, the '/r' reloads and saves the .qvw and the third section is the filepath to the .qvw you wish to reload.

You can create it in Notepad and alter the extension to .bat from .txt, then all you need to do is use standard Windows Sheduler to run the batch file every hour or whenever you wish.

All the best,

Matt - Visual Analytics Ltd

[#8]

Hi Guys

Than you all for your time and answers, I dont have Windows Scheduler either !!! But I am in talking with IT to try and get it activated !!! This is the probable route I will go

Thanks again

A

[#9]

Hi

When I set a qv to reload every hour, will it refresh the browser?  The exec wants the dashboard displayed on a monitor and refreshed automatically.  I am totally new at this.

Thanks

Rox

[kaushiknsolanki]

Yes

      All you need to do is to do some settings.

      Open the application on QlikView Desktop. Go to Settings-> Document Properties -> Server -> "Refresh Mode when Document is Updated on Server" Set this to "Server performs refresh automatically without clients action"

      Click on Apply and save the application.

Regards,

Kaushik Solanki