Discussion board where members can learn more about Qlik Sense App Development and Usage.
I a got a set of data that shows like this: 4/16/2018 2:30:30 PM as the picture, what I am trying to do is to show like this:
(4/16/2018 2 PM), (4/16/2018 3 PM) I just need the date and the hour, if someone know how to it will be a great help!!.
Go to Solution.
May be this
TimeStamp(TimeStamp#(Left(TimeStamp(FieldName, 'MM/DD/YYYY hh:mm:ss'), 13), 'MM/DD/YYYY hh'), 'MM/DD/YYYY hh TT') as NewField
So, something like this will be rounded up? or rounded down?
4/16/2018 2:30:30 PM
That will be fine, we just want to filter by date and hour we don't care about the minutes
the Hours will be different depending on how you will round (up or down)
Thank you Sunny!!! is working