topic Re: Need help with hours in charts in QlikView https://community.qlik.com/t5/QlikView/Need-help-with-hours-in-charts/m-p/459266#M1161336 <HTML><HEAD></HEAD><BODY><P>cOUNT(interval(time#(timestamp,'HH:MM:SS'),'HH'),contact)</P><P>hope it helps you</P></BODY></HTML> Fri, 21 Dec 2012 10:08:47 GMT er_mohit 2012-12-21T10:08:47Z Need help with hours in charts https://community.qlik.com/t5/QlikView/Need-help-with-hours-in-charts/m-p/459264#M1161334 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P>So the problem I have is that I have a table with timestamps looking like this: HH:MM:SS, and I want to find a resonable easy way to just show the hours in a chart that displays how many stamps i have for each hour. The tables name is "Tid" and each stamp connects with a "contact" in another table so I want to be able to show how many "contacts" I have for each hour.</P><P></P><P></P><P>I'm sure theres an easy way and I hope theres someone out there who could help a newbie out.</P></BODY></HTML> Fri, 21 Dec 2012 07:50:19 GMT https://community.qlik.com/t5/QlikView/Need-help-with-hours-in-charts/m-p/459264#M1161334 Meg00 2012-12-21T07:50:19Z Re: Need help with hours in charts https://community.qlik.com/t5/QlikView/Need-help-with-hours-in-charts/m-p/459265#M1161335 <HTML><HEAD></HEAD><BODY><P>Can you post the sample data</P></BODY></HTML> Fri, 21 Dec 2012 08:19:31 GMT https://community.qlik.com/t5/QlikView/Need-help-with-hours-in-charts/m-p/459265#M1161335 sreenivas 2012-12-21T08:19:31Z Re: Need help with hours in charts https://community.qlik.com/t5/QlikView/Need-help-with-hours-in-charts/m-p/459266#M1161336 <HTML><HEAD></HEAD><BODY><P>cOUNT(interval(time#(timestamp,'HH:MM:SS'),'HH'),contact)</P><P>hope it helps you</P></BODY></HTML> Fri, 21 Dec 2012 10:08:47 GMT https://community.qlik.com/t5/QlikView/Need-help-with-hours-in-charts/m-p/459266#M1161336 er_mohit 2012-12-21T10:08:47Z Re: Need help with hours in charts https://community.qlik.com/t5/QlikView/Need-help-with-hours-in-charts/m-p/459267#M1161337 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>find the attachement, it may help you</P><P></P><P></P><P>Niranjan M</P></BODY></HTML> Fri, 21 Dec 2012 11:00:17 GMT https://community.qlik.com/t5/QlikView/Need-help-with-hours-in-charts/m-p/459267#M1161337 2012-12-21T11:00:17Z