9 Replies Latest reply: Jun 2, 2012 12:04 PM by Kaushik Solanki RSS

    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

        • Re: Auto Reload in script
          Matthew 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

            • 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

                • Re: Auto Reload in script
                  Dinesh Kumar

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

                  • Re: Auto Reload in script
                    Matthew 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

                • Auto Reload in script
                  Kaushik Solanki

                  Hi,

                   

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

                   

                  Regards,

                  Kaushik Solanki

                    • 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

                      • 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
                            Kaushik Solanki

                            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