Qlikview Desktop auto-refresh

[sifatnabil]

Hi all,

I would like to set a regular refresh of the QV desktop client, e.g. every minute. How can this be done? Can I utilize now() ?

[Chanty4u]

i thnk use   windows scheduler

chk dis

Batch file & windows scheduler

[jagan]

Hi,

Use batch file to reload the Qlikview Dashboard and schedule it in Windows task scheduleer.

Batch file script to reload Qlikview Applications

Quick Development Tips: Qlikview: How to refresh/reload data automatically in qlikview desktop

Regards,

Jagan.

[sifatnabil]

Hi - this wouldn't actually work for my use case. I know how to run batch file reloads, but this is a qvw which has a straight table, and the data refreshes every minute. I would thus like the reload to happen while the qvw is open, so that I can see the table update happen on my desktop. Can this be done?

[Anonymous]

This isn't really the kind of thing QlikView was intended for, as it is a BI / Data Discovery tool.

[jagan]

Hi,

It is not possible, once the file is opened you have to reload manually or writing some macros.  If your data is dynamic you can use Qlik's Direct Discovery feature

Direct Discovery

Direct Discovery

[sifatnabil · Accepted solution]

Hi guys,

This method works to auto-refresh on the desktop client:

1) Create a variable vTriggerReload with expression "=if(left(subfield((now()-ReloadTime())*1440,'.',2),1)=5,999,0)" for every 0.5 minute refresh.

2) Create this macro:

Sub ReloadDoc

   ActiveDocument.Reload

   ActiveDocument.Save

End sub

3) Set variable event trigger OnChange for vTriggerReload, run macro "ReloadDoc"

I modified this method from Lucian Cotea's because his one seems to only work for SR2 and above. The above steps work on all versions of QV.

[bvssudhakar]

Hi Sifat Rahman,

I did same thing for my qvw also but there is some issue i am facing. It is reloading only when the document is in open state but i want when document is in closed state also it will reload automatically... can you give me the suggestion where should i change and how to do it

Thank you in advance

Sudhakar

[sifatnabil]

Hi, to get this while the document is closed, you cannot use this method at all. You will have to write a batch file and setup a task on Windows Task Scheduler.

Batch file should look like this:

echo off

echo.

echo Initialize the log file with Command Line reload...

echo Run QlikView and Reload Data...

"C:\Program Files\QlikView\Qv.exe" /r "\\YourFilePath\Dataload5.qvw"

Then setup this batch file on Task Scheduler

[bvssudhakar]

Hi Sifat,

Thank you for your response. here i am attaching my qvw file if possible can you create the batch file for that because i don't have any idea about batch file.

I am using desktop edition so write that creation method and script. It will very useful for me

Thank you in advance

Sudhakar