Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Auto Reload in script

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

9 Replies
Luminary
Luminary

Re: Auto Reload in script

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

Auto Reload in script

Hi,

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

Regards,

Kaushik Solanki

Not applicable

Auto Reload in script

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

Not applicable

Auto Reload in script

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
Valued Contributor

Re: Auto Reload in script

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

Luminary
Luminary

Re: Auto Reload in script

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

Not applicable

Re: Auto Reload in script

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

Not applicable

Auto Reload in script

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

Auto Reload in script

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

Community Browser