topic Re: Display time in hourly format in QlikView

Display time in hourly format

mandilicious — Wed, 25 Nov 2020 16:16:04 GMT

Hi All

Please assist i need to display time in below graph to be hourly e.g 8:00,9:00,10:00,11:00,12:00,13:00?

Thanks

Re: Display time in hourly format

Anil_Babu_Samineni — Mon, 11 Dec 2017 11:43:54 GMT

May be attach to test?

Re: Display time in hourly format

qlikcheepirishe — Mon, 11 Dec 2017 11:52:02 GMT

=floor('Time field') in the dimension use it

Re: Display time in hourly format

mandilicious — Mon, 11 Dec 2017 11:54:35 GMT

Hi Anil

Thank for your quick response below is format of my time?let me know if you need more info.

20:49:25

20:50:25

11:53:39

12:07:56

12:47:46

12:51:37

18:51:42

11:35:37

09:16:42

10:10:57

10:38:36

14:00:03

14:00:08

13:50:53

08:33:10

16:58:32

17:37:56

16:13:16

17:34:26

17:35:21

11:35:41

15:33:21

16:18:14

16:22:44

18:10:32

18:10:35

18:10:36

18:16:09

Re: Display time in hourly format

Anil_Babu_Samineni — Mon, 11 Dec 2017 11:59:46 GMT

If possible, Please attach QVW that may demon the issue

Re: Display time in hourly format

mandilicious — Mon, 11 Dec 2017 12:01:14 GMT

Hi Mahesh

Thanks,

After applying what you suggested my graph went blank. my Time field is grab_time.

i used below in my dimension

=floor('grab_time')

Re: Display time in hourly format

Chanty4u — Mon, 11 Dec 2017 12:05:08 GMT

check here same requirement matching here

Rounding timestamp to hour

Re: Display time in hourly format

sunny_talwar — Mon, 11 Dec 2017 12:17:54 GMT

Have you tried Hour() function in your dimension?

Hour([grab_time])

Re: Display time in hourly format

Chanty4u — Mon, 11 Dec 2017 12:21:06 GMT

small addition

he want with : 00 so you can this also to sunny answer i think

=hour('Grab_time')&':00'

Re: Display time in hourly format

sunny_talwar — Mon, 11 Dec 2017 12:25:31 GMT

Is it that important for the OP to see :00. If it is, then i would just use this instead of making the field text

Time(Floor(grab_time, 1/24), 'h:mm')

Re: Display time in hourly format

mandilicious — Mon, 11 Dec 2017 12:30:32 GMT

Hi Sunny

Thanks it look like it is working. please help i need this to be displayed in ascending order?

Re: Display time in hourly format

sunny_talwar — Mon, 11 Dec 2017 12:33:32 GMT

Sort your dimension numerically on the sort tab

Re: Display time in hourly format

mandilicious — Mon, 11 Dec 2017 12:39:11 GMT

Thanks for your help i really appreciate it

Re: Display time in hourly format

mandilicious — Mon, 11 Dec 2017 12:39:46 GMT

Working perfect.Thank you

Re: Display time in hourly format

mandilicious — Mon, 11 Dec 2017 12:40:04 GMT

Thanks for your help i really appreciate it

Re: Display time in hourly format

mandilicious — Mon, 11 Dec 2017 12:40:54 GMT

Thanks for your help i really appreciate it