Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
MrJanjua
Contributor II
Contributor II

Bar Chart with Time

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

Like

 

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
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
Labels (1)
1 Solution

Accepted Solutions
Or
MVP
MVP

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.

View solution in original post

1 Reply
Or
MVP
MVP

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.