Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

victor_greffet
New Contributor III

Store compared date in variable

Hi Community,

I am beginner in Qlik development.


In my app I loaded different database (Excel files),

I get the full date of my four Excel files by using the FileTime() function and i would like to store the most recent date of these four files in a variable called vFileTime.

LET var1 = FileTime(File1)

LET var2 = FileTime(File2)

LET var3 = FileTime(File3)

LET var4 = FileTime(File4)


Do you have an idea ?

Thank you,

Victor

Tags (2)
3 Replies
MVP
MVP

Re: Store compared date in variable

let vFileTime= RangeMax(var1, var2, var3, var4);

victor_greffet
New Contributor III

Re: Store compared date in variable

Simple and efficient, thank you !

MVP
MVP

Re: Store compared date in variable