topic Re: Automatic Reload Script in QlikView

Automatic Reload Script

Fri, 09 Apr 2010 12:38:51 GMT

Hi,

This is just a simply question.

I take data from an ERP system to run a Qlickview file. But, how can I automaticly reload the script every time the user opens the file?

I mean, without using the upper botton to reload. And even more...how can I make to reload it every 60 mins?

Thanks in advance.

Sitopons.

Automatic Reload Script

Fri, 09 Apr 2010 12:49:00 GMT

Hi sitopons,

As per my knowledge you can do like.

Normal 0 false false false MicrosoftInternetExplorer4

1) Scheduling

2) Write macro "ActiveDocument.Reload()" and document properties on triggers Tab select onopen and assign that trigger.

Regards,

Ravi...

Normal 0 false false false MicrosoftInternetExplorer4

Re: Automatic Reload Script

Tue, 26 Feb 2013 12:30:36 GMT

hi sitopons,

in tools-edit module

write

sub autoreload

activeDocument.reload

end sub

then

clike ok

after that in

Setting - Document Properties - On Open - Add actions - External - Run Macro -

enter your macro name

in this case is autoreload

save your doc and reopen

Re: Automatic Reload Script

Emmanuelle__Bustos — Tue, 14 May 2013 17:40:53 GMT

Thanks a lot hamide.gh it works for me!!! but just one correction in Document properties you have to go to "Triggers" instead of "On Open".

Regards

Re: Automatic Reload Script

Thu, 03 Oct 2013 13:35:02 GMT

Hi Hamide,

I had the similar requirement to refresh the data from a MS access DB ( I am using ODBC in reload script as below). The above steps does not run or Am I missing something ?

ODBC CONNECT TO [QV_DSN;DBQ=Z:\IDLM\Dev\Sample\IDLM Database v0.5 Oct01.accdb];
SQL SELECT * FROM Currentdata;
I am connecting current data to the dashboard and wanted to get it refreshed as the table changes. Could you please help ?

Re: Automatic Reload Script

Thu, 03 Oct 2013 15:57:56 GMT

Hello,

It worked..i had to turn off the webview.

thanks