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: 
raissaThibes
Contributor
Contributor

FileTime seems work differently in Qlik Cloud

Hi

I always used FileTime() to discover if a file is new or even if it exists using Qlik SaaS

However, as I'm migrating to Qlik Cloud I'm struggling to keep some things, such as discovering if a file exists in a OneDrive connection. How is the appropriate sintax?

I wrote

Let filename = 'XYZ FY23 P5.xlsx';
Set path_filename = '[lib://DigitalFinance_.../$(filename)]';
Let fileTime = Trim(FileTime('$(path_filename)'));
Let sizeFileTime = Len(Trim(FileTime('$(filename)')));

 

All I get sizeFileTime = <NULL>

Labels (1)
0 Replies