Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
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.