Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello qlikers 🙂 ,
LET vTimeStamp = TimeStamp(Now());
I get the TimeStamp from the last reload. But when vTimeStamp greater than 36 hours is he should do something.
How can I write this in qlik sense?
IF(TimeStamp(Now()) > vTimeStamp + 36 Hours)
// do something
else
// do something other stuff
Thank you in advance! Looking forward to reading some answers. 🙂
Hi,
You can write it like this:
IF TimeStamp(Now()) > (vTimeStamp + (36 / 24)) THEN
// do something
ELSE
// do something other stuff
ENDIF
Best Regards,
Nicolas
Hi,
You can write it like this:
IF TimeStamp(Now()) > (vTimeStamp + (36 / 24)) THEN
// do something
ELSE
// do something other stuff
ENDIF
Best Regards,
Nicolas
IF((interval(TimeStamp(Now()) - $(vTimeStamp),'hh')*24) >36 then
// do something
else
// do something other stuff