topic Re: Store compared date in variable in App Development

Store compared date in variable

victor_greffet — Tue, 17 Oct 2017 20:33:03 GMT

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

Re: Store compared date in variable

maxgro — Tue, 17 Oct 2017 21:23:50 GMT

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

Re: Store compared date in variable

victor_greffet — Wed, 18 Oct 2017 05:49:38 GMT

Simple and efficient, thank you !

Re: Store compared date in variable

maxgro — Wed, 18 Oct 2017 06:40:20 GMT

Qlik Community Tip: Marking Replies as Correct or Helpful