topic Re: Qlikview Desktop auto-refresh in QlikView

Qlikview Desktop auto-refresh

sifatnabil — Tue, 16 Feb 2016 09:14:09 GMT

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() ?

Re: Qlikview Desktop auto-refresh

Chanty4u — Tue, 16 Feb 2016 09:18:58 GMT

i thnk use windows scheduler

chk dis

Batch file & windows scheduler

Re: Qlikview Desktop auto-refresh

jagan — Tue, 16 Feb 2016 09:27:58 GMT

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.

Re: Qlikview Desktop auto-refresh

sifatnabil — Tue, 16 Feb 2016 16:20:08 GMT

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?

Re: Qlikview Desktop auto-refresh

Anonymous — Tue, 16 Feb 2016 16:25:49 GMT

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

Re: Qlikview Desktop auto-refresh

jagan — Wed, 17 Feb 2016 01:07:45 GMT

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

Re: Qlikview Desktop auto-refresh

sifatnabil — Wed, 17 Feb 2016 10:20:32 GMT

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.

Re: Qlikview Desktop auto-refresh

bvssudhakar — Wed, 09 May 2018 07:27:36 GMT

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

Re: Qlikview Desktop auto-refresh

sifatnabil — Wed, 09 May 2018 09:22:49 GMT

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

Re: Qlikview Desktop auto-refresh

bvssudhakar — Wed, 09 May 2018 09:41:37 GMT

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

Re: Qlikview Desktop auto-refresh

sifatnabil — Wed, 09 May 2018 09:47:04 GMT

See the attached batch file. You then need to create a task on Windows Task Scheduler that will execute this batch file.

Re: Qlikview Desktop auto-refresh

oseimuduame — Tue, 17 Jul 2018 16:56:11 GMT

Hello Saifat Rahman,

Please how do i increase the Auto refresh time to like 15minutes or 10 minutes

or if you can explain this script

=if(left(subfield((now()-ReloadTime())*1440,'.',2),1)=5,999,0)

Re: Qlikview Desktop auto-refresh

Mawkishrains — Thu, 11 Jun 2020 06:31:29 GMT

Does this method still work, I did create the variable and the macro, but the refresh doesnt trigger automatically, i have to manually update the variable for the change to work, how can i define a variable that is in memory and automatically updates? does this method work for any one? can someone help me understand what am i doing wrong here?

Re: Qlikview Desktop auto-refresh

SOR124248 — Thu, 07 Jan 2021 10:43:04 GMT

Not sure if this will help or not. But for the sake of how I get this to work..
I use a very basic Windows PowerShell script.

When I've used Windows Scheduler in the past, I've had issues getting it to run.
I believe it's something to do with the user security within Windows, which I won't go into, I'm sure someone can confirm.
I decided to create a PowerShell script that sort of works like it's own scheduler.
This is VERY simple version of my code, I have removed the dynamic features such as passing parameters etc.

------------------------------------------------------------------------------------------------------------
Function Load_Data {
While ( $true ) {
Run-QlikReport
Start-Sleep -Seconds 60
}
}

Function Run-QlikReport {
Start-Process "C:\Program Files\Qlikview\qv.exe" "/r C:\Qlik\Load_QVD.qvw" -Wait
}

Load_Data
------------------------------------------------------------------------------------------------------------

Breaking this down
While ($true) <-- This will run an 'infinite' loop

Start-Process <-- Powershell command for running an external application/script
C:\Program Files\Qlikview\qv.exe <-- Qlikview application path
/r <-- send parameter to QV to refresh and save.
C:\Qlik\Load_QVD.qvw" <-- Location of the qvw to be refreshed.
-Wait <-- PowerShell parameter to force the script to wait until QV finishes the refresh.

I then just run this on the machine all the time.
You can obviously include several files, change the amount of wait time between refreshes etc.
It works well for me.

Re: Qlikview Desktop auto-refresh

dobrien7 — Tue, 09 Feb 2021 11:12:19 GMT

The variable/trigger/macro method is a great summary. Thanks so much.

However, when I do this I get a reload happening every few seconds, even with a higher trigger value [i.e. 0.8 minutes] to produce the rising edge. I can only imagine that each reload results in a falling edge of the vTriggerReload trigger, and the OnChange picks up this falling edge as a change, thus continually provoking a fresh reload. It eventually stops reloading and waits for the counter to reach threshold again. Number of reloads before settling down can vary between 3 and 35

Perhaps I'm very wrong with that assumption, but either way I'd very much appreciate any feedback on additional steps to avoid what I'm experiencing. Many thanks