Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Meg00
New Contributor III

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.

3 Replies
sreenivas
Contributor III

Re: Need help with hours in charts

Can you post the sample data

er_mohit
Honored Contributor II

Re: Need help with hours in charts

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

hope it helps you

Not applicable

Re: Need help with hours in charts

Hi,

find the attachement, it may help you

Niranjan M