topic Re: File Names in QlikView

File Names

Fri, 13 Mar 2015 15:00:58 GMT

Hi All

Is there any way Qlikview can extract the Date Modified from the folder the Qlikview File is in as my client want's to have this shown in a report. This can not be run by a Macro.

Re: File Names

stigchel — Fri, 13 Mar 2015 15:03:17 GMT

You can use the FileTime() function to retrieve the modification date

Re: File Names

stigchel — Fri, 13 Mar 2015 15:07:19 GMT

An example for a way to determine how many days ago the qvw was reloaded:

LET vDaysAgo = Now() - FileTime('MyQvw.qvw');

Re: File Names

Fri, 13 Mar 2015 15:09:11 GMT

Thanks Piet

Do you have a one line example as I have just tried that and I got nothing back.

Re: File Names

its_anandrjs — Fri, 13 Mar 2015 15:09:31 GMT

Hi,

You can read the Filename() or FileBaseName() if the file name and the updated time mention in the file name. And then you can store it any table or variables as well as.

Regards

Anand

Re: File Names

stigchel — Fri, 13 Mar 2015 15:17:13 GMT

That was an example, have you included the path to the file e.g. 'C:\MyDocuments\MyQvw.qvw' ?

Re: File Names

Fri, 13 Mar 2015 15:19:19 GMT

Hi, There is very good example in QV help.

Se operator FOR EACH .. NEXT

Examples:

FOR Each a in 1,3,7,'xyz'

LOAD * FROM file$(a).csv;

// list all QV related files on disk

SUB DoDir (Root)

FOR Each Ext in 'qvw', 'qva', 'qvo', 'qvs'
FOR Each File in filelist (Root&' \*.' &Ext)
LOAD
'$(File)' as Name,
FileSize( '$(File)' ) as Size,
FileTime( '$(File)' ) as FileTime
autogenerate 1;
NEXT File
NEXT Ext

FOR Each Dir in dirlist (Root&' \*' )
call DoDir (Dir)

NEXT Dir

ENDSUB

CALL DoDir ('C:')