Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
shamitshah
Partner - Creator
Partner - Creator

Auto reload

Hi,

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

Appreciate your guidance.

Shamit

1 Solution

Accepted Solutions
Frank_Hartmann
Master II
Master II

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

View solution in original post

14 Replies
muthukumar77
Partner - Creator III
Partner - Creator III

vikasmahajan

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

Windows Task Schedular.docx

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
sujeetsingh
Master III
Master III

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

susovan
Partner - Specialist
Partner - Specialist

Hi Shamit,

Check this link,

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

Warm Regards,
Susovan
Digvijay_Singh

Check this as well -

Run qvw from batch

Frank_Hartmann
Master II
Master II

See attached File

Hope this helps!

shamitshah
Partner - Creator
Partner - Creator
Author

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
Master II
Master II

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
Partner - Creator
Partner - Creator
Author

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