topic Re: Getting hour from Time Stamp in QlikView

Getting hour from Time Stamp

reshmakala — Wed, 13 Jul 2016 17:41:24 GMT

Hello all,

I have an application with the order details. I want to show a drill down with Year, Month, Weekday and time of the day.

Year, month and Weekday was easy but when I try to extract hour from the order creation date, I get multiple records for same value.

I need something like below:

For 2016 -> Jan -> Tue -> between 00-01 there are 35332 orders placed.

Attached are the sample qvw and excel sheet. Please help me with this,

swuehl — Wed, 13 Jul 2016 17:43:47 GMT

Use

Hour([CREATED TIMESTAMP]) as Hour

Anonymous — Wed, 13 Jul 2016 17:47:20 GMT

see the attached app

reshmakala — Wed, 13 Jul 2016 17:47:30 GMT

Thank you so much. That was pretty straight forward.