topic Re: Auto ReLoad and save Every 15 min in QlikView

Auto ReLoad and save Every 15 min

gidon500 — Wed, 25 Nov 2020 16:16:04 GMT

Hi Guys

I have A documents that takes 30 sec to reload ,

It is status of Service call .

the documents is open on BIG screen , I need it to auto reload and save every 15 minutes

How can I do it

thanks

Gidon

Re: Auto ReLoad and save Every 15 min

its_anandrjs — Wed, 09 Nov 2016 20:44:59 GMT

You have to create the task for this for auto data refresh.

1. By the Windows task scheduler.

2. By the QMC (Qlikview Management Console)

By creating the task for the Qlikview file.

Regards,

Anand

Re: Auto ReLoad and save Every 15 min

gidon500 — Thu, 10 Nov 2016 07:16:31 GMT

Hi Anand

I am not familiar of the QMC ?

is it an qlik option to buy ?

thanks

gidon

Re: Auto ReLoad and save Every 15 min

Anil_Babu_Samineni — Thu, 10 Nov 2016 07:23:50 GMT

No worries, How you are deploying the qvw on access point to show the users?

Re: Auto ReLoad and save Every 15 min

gidon500 — Thu, 10 Nov 2016 08:18:38 GMT

Hi Anil

this is going to be a PC

Connected to the company network .

and a BIG screen on the wall

Gidon

Re: Auto ReLoad and save Every 15 min

kaushiknsolanki — Thu, 10 Nov 2016 08:36:50 GMT

Hi Gidon,

As Anand said, you can do 2 options.

1. By the Windows task scheduler. (This is an inbuilt functionality of Windows where you can schedule batch files and run them at regular intervals.

2. By the QMC (Qlikview Management Console) - This is a functionality which is available when you buy the Qlik Enterprise version.

Below link will help you to understand how to create a batch file.

Batch file script to reload Qlikview Applications

Regards,

kaushik Solanki

Re: Auto ReLoad and save Every 15 min

Anonymous — Thu, 10 Nov 2016 08:37:35 GMT

Are you using QlikView Desktop to view the qvw, or a web browser to access a QlikView Sever ?

Re: Auto ReLoad and save Every 15 min

gidon500 — Thu, 10 Nov 2016 10:06:31 GMT

I am using qlikview desktop

Gidon

Re: Auto ReLoad and save Every 15 min

Peter_Cammaert — Thu, 10 Nov 2016 14:22:13 GMT

luciancotea wrote a nice article about how to do this in QV Desktop here: Auto reload every 10 minutes – desktop client | Lucian Cotea

Best,

Peter

Re: Auto ReLoad and save Every 15 min

tamilarasu — Thu, 10 Nov 2016 15:01:46 GMT

Hi Gidon,

Hope the below link might be helpful.

https://community.qlik.com/thread/234490?sr=stream&ru=51107#1133195

Re: Auto ReLoad and save Every 15 min

Frank_Hartmann — Thu, 10 Nov 2016 15:58:28 GMT

have alook at the attached sample.

it will reload and save the document every 15 minutes

hope this helps

Re: Auto ReLoad and save Every 15 min

vardhancse — Thu, 10 Nov 2016 16:08:09 GMT

Hi,

PFA document for your reference.

Re: Auto ReLoad and save Every 15 min

gidon500 — Thu, 10 Nov 2016 16:37:13 GMT

thanks

works fine

gidon

Re: Auto ReLoad and save Every 15 min

bvssudhakar — Tue, 08 May 2018 10:37:09 GMT

Hi Frank,

I tried with my own data based on your file but it's not working, I think i did a minor mistake but i am not getting where i did that mistake can you find tell me it will very useful for me

And it's an urgent requirement

Here i am attaching the file also

Re: Auto ReLoad and save Every 15 min

Frank_Hartmann — Tue, 15 May 2018 10:55:45 GMT

Sorry for late response:

You will have two things to change/add:

1. Script:

replace SET TimeFormat='h:mm:ss TT'; with SET TimeFormat='hh:mm:ss';

2. Just add an action to ReloadTrigger on change :

Settings--->DocumentProperties---->Triggers--->ReloadTrigger--->OnChange--->AddActions--->Add--->Run Macro--->Macro Name = ReloadDoc

hope this helps