Display Value of date field which are older than 48 hours

[Arvind_Singh]

Hi,

I have a table as shown below -

Last_update_time	Ticket Number
2020-06-17 19:01:02	5685412
2020-06-16 00:12:27	2541785
2020-06-15 23:31:51	5214587
2020-06-15 10:02:10	3265974
2020-06-12 10:15:42	2541957
2020-06-05 00:24:20	3524178

I am looking for an expression to display only those Tickets for which the Last_update_time is 48 hours older than the current time.

So the expression should return below output -

Ticket Number

3265974

2541957

3524178

Thanks in advance for help 🙂.

[tresesco · Accepted solution]

Try like:

if(Last_update_time<now()-2, [Ticket Number])

[Arvind_Singh]

Thanks for helping with the Expression.
Could you please let me know how can the same expression be written if I have to display the fields which are older than 15 hours. 

[tresesco · Accepted solution]

In qlik,

1 is equivalent to 1 day. Therefore, rest of the calculations are very straight forward.

1/24 =~ 1 hour

1/24/60 =~ 1 minute

1/24/60/60 =~ 1 second

Now you can calculate for 15 hours - it's  1/24*15