Auto reload

[shamitshah]

Hi,

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

Appreciate your guidance.

Shamit

[muthukumar77]

Hi,

Refer this site,

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

[vikasmahajan]

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

Windows Task Schedular.docx

Vikas

[sujeetsingh]

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

[susovan]

Hi Shamit,

Check this link,

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

[Digvijay_Singh]

Check this as well -

Run qvw from batch

[Frank_Hartmann]

See attached File

Hope this helps!

[shamitshah]

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

[Frank_Hartmann · Accepted solution]

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

[shamitshah]

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