topic Re: filetime function in QlikView

filetime function

souadouert — Mon, 29 Jan 2018 16:22:25 GMT

I used filetime function with qlikview MACRO to test the file exist

if isnull(filetime("D:\MACROTEST\VISION1.csv")) then

msgbox("")

else

sgbox

end if

and i have this error Type mismatch: 'filetime'

Re: filetime function

sunny_talwar — Mon, 29 Jan 2018 16:27:51 GMT

May be try something like this

vFileTime = ActiveDocument.Evaluate("If(IsNull(FileTime('D:\MACROTEST\VISION1.csv')), 1, 0)")

If vFileTime = 1 then

msgbox("")

else

sgbox

end if

Re: filetime function

CarlosAMonroy — Mon, 29 Jan 2018 22:08:32 GMT

Hi Souad,

I have tried FileTime() and it works fine. Would be good if you share a sample file.

Otherway you can try using other functions like:

if len(FileSize('file_name')) > 0 THEN

...

ELSE

...

ENDIF

Hope that helps,

Carlos M

Re: filetime function

tamilarasu — Tue, 30 Jan 2018 03:11:12 GMT

Hi Souad,

You can also try

Sub Test

Set FSO = CreateObject("scripting.filesystemobject")

If FSO.FileExists("D:\MACROTEST\VISION1.csv") = true Then

Msgbox "Yes"

Else

Msgbox "No"

End If

End Sub

Note: You need to enable "Allow System Access" option in the current local security.

Re: filetime function

tamilarasu — Tue, 30 Jan 2018 03:18:11 GMT

Hi Sunny,

Hope you are doing good!

I think FileTime function in macro does not work. I believe only chart functions (not script functions) can be evaluated through macro.

You can try any script functions inside the below syntax and you will see "Its not a valid function" error message.

Msgbox ActiveDocument.Evaluate("Any Script Function")

Re: filetime function

sunny_talwar — Tue, 30 Jan 2018 13:07:00 GMT

Make sense... I used a chart function before like that, so I thought this might work as well . Thanks for pointing it out tamilarasu