Discussion board where members can learn more about Qlik Sense App Development and Usage.
I want to create an age bucket based on , open ticket with last reloadedtime()
considering date as last reloaded time and ticket created time.
thanks in advance
You can simply subtract 1 date field from another.
ReloadField - TicketOpenedField
Since both are likely timestamp values you will have decimals involved. Which may be a good thing if you want to know that something may be a few hours after 1 whole day.
But if you only want to know in terms of sheer calendar dates then you will want to use the FLOOR function.
Floor(ReloadField) - Floor(TicketOpenedField)
Then you can either use the CLASS function to auto bucket or simply use a series of nested IF conditions.
View solution in original post