topic Re: Auto reload in QlikView

Auto reload

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

Hi,

In the absence of a QlikView server, how can I set up my QlikView desktop version to reload automatically?

Appreciate your guidance.

Shamit

Re: Auto reload

muthukumar77 — Wed, 22 Jun 2016 04:27:38 GMT

Hi,

Refer this site,

Configuring a reload schedule (QlikView) - QVSource: The QlikView & Qlik Sense API Connector (Docs)

Re: Auto reload

vikasmahajan — Wed, 22 Jun 2016 04:30:24 GMT

you can create a batch file and execute the same through windows scheduler. Refer this link

Windows Task Schedular.docx

Vikas

Re: Auto reload

sujeetsingh — Wed, 22 Jun 2016 04:37:27 GMT

You can use QV server and even use Windows batch schedule.

Re: Auto reload

susovan — Wed, 22 Jun 2016 04:44:34 GMT

Hi Shamit,

Check this link,

http://wiki.qvsource.com/Configuring-a-reload-schedule.ashx

Re: Auto reload

Digvijay_Singh — Wed, 22 Jun 2016 05:03:58 GMT

Check this as well -

Run qvw from batch

Re: Auto reload

Frank_Hartmann — Wed, 22 Jun 2016 05:19:23 GMT

See attached File

Hope this helps!

Re: Auto reload

shamitshah — Wed, 22 Jun 2016 05:58:25 GMT

Hi Frank,

Thanks for the file. Is there any documentation/explanation that will help me in understanding how it works so that I can try and incorporate and test in my files?

Shamit

Re: Auto reload

Frank_Hartmann — Wed, 22 Jun 2016 06:14:44 GMT

In script you need to add:

LET ReloadNo = ReloadNo + 1;

You need to create 3 Variables:

Settings->VariableOverview->AddVariable

ReloadTrigger=if( (Now() - ReloadTime())*1440 >= ReloadMinutes, Now(), 0)

ReloadNo

RealoadMinutes

In Module you will have to add:

Sub ReloadDoc

ActiveDocument.Reload

ActiveDocument.Save

End sub

Finally go to settings-->DocumentSettings-->Triggers-->VariableEventTriggers-->Select "ReloadTrigger" and add Actions-->Run Macro --> ReloadDoc

The ReloadTrigger will calculate the time difference respective the Value of ReloadMinutes you entered!

For ReloadMinutes=5 the script automatically reloads every 5 minutes

Hope this helps

Re: Auto reload

shamitshah — Wed, 22 Jun 2016 07:19:06 GMT

Hi Frank,

Please see attached file that I created based on the above.

I have set the ReloadMinutes to 1, but it does not appear to reload every minute.

Any idea where I have gone wrong or missed something?

Appreciate your assistance.

Thanks

Shamit

Re: Auto reload

Frank_Hartmann — Wed, 22 Jun 2016 07:28:42 GMT

you need to set:

ReloadTrigger=if( (Now() - ReloadTime())*1440 >= ReloadMinutes, Now(), 0)

then it should work!

Re: Auto reload

shamitshah — Wed, 22 Jun 2016 07:35:47 GMT

Figured that I had missed the value in the Reload Trigger.

Thanks

Shamit

Re: Auto reload

shamitshah — Wed, 22 Jun 2016 07:38:12 GMT

Thanks Frank,

Any idea how I can do the same in Qlik Sense?

Thanks

Shamit

Re: Auto reload

Frank_Hartmann — Wed, 22 Jun 2016 07:46:47 GMT

Qliksense does not have macro editor.

So this workaround is only for Qlikview!

Re: Auto reload

hectorgarcia — Wed, 01 Jul 2020 20:19:41 GMT

quick question.
If the reload time takes more than the time the set in the variable, what will happen? will allow the current reload ends? or

kill the current one and start a new reload...