Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content
Announcements
WEBINAR April 23, 2025: Iceberg Ahead: The Future of Open Lakehouses - REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
firoz24
Creator
Creator

Qlik modified timestamp

Hello Guys,

I need a timestamp regarding the last modified date of excel as kpi 

For ex : In excel my data last updated on 18/12/2023 at 08:50 am etc..

Thank you 

Labels (3)
1 Solution

Accepted Solutions
Vegar
MVP
MVP

You could make use of the FileTime() function to catch the timestamp. The FileTime() function returns a timestamp of the last modification of a specified file. 

https://help.qlik.com/en-US/sense/August2023/Subsystems/Hub/Content/Sense_Hub/Scripting/FileFunction...

View solution in original post

1 Reply
Vegar
MVP
MVP

You could make use of the FileTime() function to catch the timestamp. The FileTime() function returns a timestamp of the last modification of a specified file. 

https://help.qlik.com/en-US/sense/August2023/Subsystems/Hub/Content/Sense_Hub/Scripting/FileFunction...