topic Visual Cues comparing time in QlikView https://community.qlik.com/t5/QlikView/Visual-Cues-comparing-time/m-p/315859#M1192371 <HTML><HEAD></HEAD><BODY><P>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.</P><P></P><P>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. </P><P></P><P>Sample Data attached.</P></BODY></HTML> Thu, 23 Jun 2011 14:04:38 GMT 2011-06-23T14:04:38Z Visual Cues comparing time https://community.qlik.com/t5/QlikView/Visual-Cues-comparing-time/m-p/315859#M1192371 <HTML><HEAD></HEAD><BODY><P>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.</P><P></P><P>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. </P><P></P><P>Sample Data attached.</P></BODY></HTML> Thu, 23 Jun 2011 14:04:38 GMT https://community.qlik.com/t5/QlikView/Visual-Cues-comparing-time/m-p/315859#M1192371 2011-06-23T14:04:38Z Re: Visual Cues comparing time https://community.qlik.com/t5/QlikView/Visual-Cues-comparing-time/m-p/315860#M1192372 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>please find attached file. Is this how you want it?</P><P></P><P>Cheers</P><P>Arun</P></BODY></HTML> Thu, 23 Jun 2011 15:41:23 GMT https://community.qlik.com/t5/QlikView/Visual-Cues-comparing-time/m-p/315860#M1192372 2011-06-23T15:41:23Z Visual Cues comparing time https://community.qlik.com/t5/QlikView/Visual-Cues-comparing-time/m-p/315861#M1192373 <HTML><HEAD></HEAD><BODY><P>Yes it is. You have no idea how long I messed with this trying to get it to work. Appreciate you help.</P><P></P><P>DR</P></BODY></HTML> Thu, 23 Jun 2011 16:13:40 GMT https://community.qlik.com/t5/QlikView/Visual-Cues-comparing-time/m-p/315861#M1192373 2011-06-23T16:13:40Z Re: Visual Cues comparing time https://community.qlik.com/t5/QlikView/Visual-Cues-comparing-time/m-p/315862#M1192374 <HTML><HEAD></HEAD><BODY><P>No problemo.. its a small change to ur script...I have used comments to show where i have made the change. </P><P>Can you mark the discussion as answered.</P><P></P><P>Cheers</P><P>Arun</P></BODY></HTML> Thu, 23 Jun 2011 16:18:58 GMT https://community.qlik.com/t5/QlikView/Visual-Cues-comparing-time/m-p/315862#M1192374 2011-06-23T16:18:58Z