Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

megalomania
Not applicable

Need help with hours in charts

Hi,

So the problem I have is that I have a table with timestamps looking like this: HH:MMSmiley FrustratedS, 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
Not applicable

Re: Need help with hours in charts

Can you post the sample data

er_mohit
Not applicable

Re: Need help with hours in charts

cOUNT(interval(time#(timestamp,'HH:MMSmiley FrustratedS'),'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