Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Visual Cues comparing time

I have some timestamp data of employee entry/exit times and I'm trying to highlight times in a straight chart that the employee arrives late, stays late or leaves early but am having some difficulty in making a 'time' comparison work.

I have the entry time via a timestamp format down to hh:mm:ss (07:30:00) and compare it to a MakeTime(9,0,0) in the Visual cues and no matter what the entry time is it is always highlighted.

Sample Data attached.

1 Solution

Accepted Solutions
Not applicable
Author

Hi,

please find attached file. Is this how you want it?

Cheers

Arun

View solution in original post

3 Replies
Not applicable
Author

Hi,

please find attached file. Is this how you want it?

Cheers

Arun

Not applicable
Author

Yes it is. You have no idea how long I messed with this trying to get it to work. Appreciate you help.

DR

Not applicable
Author

No problemo.. its a small change to ur script...I have used comments to show where i have made the change.

Can you mark the discussion as answered.

Cheers

Arun