Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Meg00
Contributor III
Contributor III
‎2012-12-21 02:50 AM

Need help with hours in charts

Hi,

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.

I'm sure theres an easy way and I hope theres someone out there who could help a newbie out.

639 Views
0 Likes
3 Replies
sreenivas
Creator III
Creator III
‎2012-12-21 03:19 AM

Can you post the sample data

500 Views
0 Likes
er_mohit
Master II
Master II
‎2012-12-21 05:08 AM

cOUNT(interval(time#(timestamp,'HH:MM:SS'),'HH'),contact)

hope it helps you

500 Views
0 Likes
Not applicable
‎2012-12-21 06:00 AM

Hi,

find the attachement, it may help you

Niranjan M

Time stamps.qvw
500 Views
0 Likes