topic Re: ReloadTime in QlikView

ReloadTime

Fri, 20 May 2016 13:59:21 GMT

Hi,

I'm struggling trying to figure out the problem with this vbscript -

Sub ReloadOnOpen

if (Date() > ReloadTime()) Then

ActiveDocument.Reload

end if

End Sub

I get the error message - "Type mismatch: 'ReloadTime'. I've seen other posts where the ReloadTime function has been used and so it ought to work. Am relatively new to qlik and would appreciate any suggestions?

Thank you.

Re: ReloadTime

marcus_sommer — Fri, 20 May 2016 14:19:21 GMT

Reloadtime() isn't a valid vbs-function - you need to adjust to this example from the APIGuide.qvw:

set docprop = ActiveDocument.GetProperties

msgbox docprop.UtcLastReloadTime

- Marcus

Re: ReloadTime

tamilarasu — Fri, 20 May 2016 14:40:37 GMT

Hi Venkatesh,

I have not tested the below code but hope this will work.

Sub Test

ReloadDate = ActiveDocument.Evaluate("Date(ReloadTime(),'DD/MM/YYYY')")

Today = ActiveDocument.Evaluate("Date(Today(),'DD/MM/YYYY')")

If Today > ReloadDate Then

ActiveDocument.Reload

Else

Msgbox "Application has already been reloaded for today!"

End If

End Sub

Re: ReloadTime

Fri, 20 May 2016 14:55:33 GMT

Hi Marcus, Tamil,

Thank you very much! That worked.

Regards,

Venkatesh

Re: ReloadTime

tamilarasu — Fri, 20 May 2016 15:18:09 GMT

Please close the thread by marking correct/helpful replies. So that it might helps others in future.

Re: ReloadTime

Fri, 20 May 2016 15:21:55 GMT

Actually, both worked. Greatly appreciate the help.