Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 🙂.
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
Try like:
if(Last_update_time<now()-2, [Ticket Number])
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.
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