topic FileTime() not working in QlikView

FileTime() not working

Wed, 25 Nov 2020 16:16:04 GMT

I'm trying capture the date of the file I'm loading into Qlik and assigning the value to a variable to be added to a dashboard.

Set $File_Date = FileTime("\\path\excel.xlsx")

The text on the object property is set to:

='Last Updated'&$File_Date

What's printing in the object box on the dashboard is:

Last Updated FileTime("\\path\excel.xlsx")

It seems so simple, but I'm new to Qlik and can't this out. Thanks for any help!

Trista

Re: FileTime() not working

Anil_Babu_Samineni — Tue, 24 Jan 2017 16:31:55 GMT

Try

='Last Updated'& $(File_Date)

='Last Updated'& '$(File_Date)'

Re: FileTime() not working

sunny_talwar — Tue, 24 Jan 2017 16:39:56 GMT

Try this may be:

Set $File_Date = FileTime('\\path\excel.xlsx')

='Last Updated' & $($File_Date)

Re: FileTime() not working

swuehl — Tue, 24 Jan 2017 16:42:52 GMT

Try with LET:

LET v_File_Date = FileTime('\\path\excel.xlsx');

Then in a text box:

= 'File time: ' & v_File_Date

Re: FileTime() not working

satheshreddy — Tue, 24 Jan 2017 16:47:23 GMT

Hi Trista,

Have you to put value in Variable?

You had used filetime(), if you want to use this You should Use LET Variable.

LET $File_Date = FileTime('\\path\excel.xlsx')

='Last Updated' & $($File_Date)

Regards

Sathish

Re: FileTime() not working

Tue, 24 Jan 2017 17:54:58 GMT

Thank you all for your prompt responses!

This is what worked.....

Script:

LET $v_File_Date = FileTime('\\path\excel.xlsx');

I didn't realize I had to end it with a semi-colon ';'.

I'm assuming prefixing with "v_", is best practice for Qlik variables...

Then in object text box:

= 'Last Updated' & $v_File_Date

The result also included both the date and time. I was looking for just the date. But, this will do.

Last Updated

1/23/2017 9:31:25 AM

[Stefan]

You can get only the date part using e.g. Dayname():

LET $v_File_Date = DayName(FileTime('\\path\excel.xlsx'));

Result:

Last Updated

1/23/2017

THANK YOU ALL!!

Re: FileTime() not working

swuehl — Tue, 24 Jan 2017 18:01:23 GMT

You can get only the date part using e.g. Dayname():

LET $v_File_Date = DayName(FileTime('\\path\excel.xlsx'));

If your request is resolved, then please close this thread by flagging helpful and/ or correct answers.

Re: FileTime() not working

Tue, 24 Jan 2017 18:13:30 GMT

Perfect Stefan! Thank you!