The FileSize function returns an integer containing the size in bytes of the file filename or, if no filename is specified, of the table file currently being read.
Syntax:
FileSize([filename])
Arguments:
- filename: The name of a file, if necessary including path. If you don't specify a file name, the table file currently being read is used.
-
absolute
Example: c:\data\
-
relative to the QlikView document path.
Example: data\
-
URL address (HTTP or FTP), pointing to a location on the Internet or an intranet.
Example: http://www.qlik.com
Examples and results:
| Example | Result |
|---|---|
|
LOAD *, FileSize( ) as X from abc.txt; |
Will return the size of the specified file (abc.txt) as an integer in field X in each record read. |
| FileSize( 'xyz.xls' ) | Will return the size of the file xyz.xls. |
