Bar Chart with Time

MrJanjua — Thu, 09 Mar 2023 11:26:07 GMT

I have a time field i wants to show time wise data with different range of time

2:30

4:00

10:50

12:25

10:20

19:35

19:00

19:20

16:00

20:50

2:40

18:45

21:40

20:30

19:20

21:00

4:00

4:30

16:30

1:15

15:35

22:45

20:55

18:00

21:00

08:00

21:30

23:00

6:00

19:50

17:15

20:15

4:30

20:00

13:20

14:40

12:30

18:30

16:45

21:25

16:30

19:00

4:30

23:25

20:00

19:15

19:40

20:54

8:15

19:25

23:55

4:30

4:00

20:50

20:20

10:50

22:30

12:30

18:20

22:30

23:00

4:30

20:30

22:30

16:30

22:00

19:00

16:45

22:30

11:18

14:00

19:10

20:30

19:25

20:20

15:40

2:00

18:00

17:12

19:00

20:00

12:20

16:00

22:15

20:40

13:55

13:45

19:15

20:00

10:10

11:00

0:05

9:50

22:20

7:55

17:30

20:25

10:00

13:00

20:15

11:53

18:45

4:30

20:10

20:50

19:00

9:50

23:10

3:00

10:00

8:10

14:00

21:20

09:45

10:45

12:50

22:00

13:00

3:30

4:00

0:15

11:22

Re: Bar Chart with Time

Or — Tue, 07 Mar 2023 12:53:11 GMT

Since your buckets are not even in size, you may as well write this out as nested if() statements

if(Time >= '08:00' AND Time < '11:00', '8-11',

if(Time >= '11:00' AND Time < '14:00','11-14)) etc - nest as many if() statements as required.

topic Bar Chart with Time in QlikView

Bar Chart with Time

Re: Bar Chart with Time