Calculated field do not come up in filter pane

[Ish_Al]

Field is created with categories in data managerNo categories populate in filter pane

Hi Qlik community,

I am trying to group a time filed [start time] for appointments into different parts of the day. I was able to successfully create the categories in data manager however the new calculated field does not show the categories in the visualization pane. I have done dimensional grouping before and but it is not working this time. Is it because I am dealing with a time dimension? See my grouping below:

 If(Match([StartTime],'8:00:00'),'First Appointment',
 If(Match([StartTime],'8:15:00'),'First Appointment',
 If(Match([StartTime],'8:30:00'),'Morning',
 If(Match([StartTime],'8:45:00'),'Morning',
 If(Match([StartTime],'9:00:00'),'Morning',

What I am doing wrong here?

[emrekaya]

Don't you need to use = sign between match(starttime) and '8:00:00' ?

[Ivan_Bozov]

Try creating the column in your load script:

LOAD
	StartTime,
	IF(MATCH(StartTime,'8:00:00','8:15:00'),'First Appointment',
	IF(MATCH(StartTime,'8:30:00','8:45:00','9:00:00'),'Morning')) AS TimeOfDay
INLINE [
StartTime
8:00:00
8:15:00
8:30:00
8:45:00
9:00:00
];

Result: