FileTime seems work differently in Qlik Cloud

raissaThibes — Tue, 11 Apr 2023 20:57:48 GMT

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>

topic FileTime seems work differently in Qlik Cloud in App Development

FileTime seems work differently in Qlik Cloud