topic Re: Timestamp subtraction in QlikView

Timestamp subtraction

sspawar88 — Fri, 10 Jul 2015 09:38:23 GMT

In table object consist ID's

if i want to check whether this ID is updated in last 5 min or not..if this is not updated i want to show in red().

is this expression correct ?

if(Max(created_date)<> Max(created_date)- 5/(24*60) ,red())

Max(created_date) is 7/8/2015 11:57:31 PM

Gysbert_Wassenaar — Fri, 10 Jul 2015 09:46:23 GMT

Max(created_date)<> Max(created_date)- 5/(24*60)

That condition will always be true.

Maybe like this: if(Max(created_date) >= now() - 5/(24*60), red() )

Fri, 10 Jul 2015 09:54:33 GMT

Hi Satish,

You have to use expression in this way.

=Timestamp(Now()-Interval('5:30','mm:ss'))

Garry

Kushal_Chawda — Fri, 10 Jul 2015 10:03:52 GMT

try,

if(num#(interval(now()-Max(created_date) ,'mm')) <=5, red())

MarcoWedel — Fri, 10 Jul 2015 11:24:02 GMT

maybe also possible:

If(Max(created_date)>=Now()-'00:05:00', Red())

hope this helps

regards

Marco