Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to capture the Created date and Last Modified date from an XLSX file in QS

Hi All,

One of my requirement is to capture the last modified date and created date from excel file from where the data is loaded. Since QlikSense does not support XLSM files can you let me know any functions that capture this as part of load statement. The data is refreshed frequently and so cannot use the last refreshed function.

Thanks in advance

Shyam

1 Reply
marcus_sommer

AFAIK qlik sense could load xlsm-files and you could get the timestamp from the file per filetime().

- Marcus