Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

Line chart with times and dates

Hi, 

My brains not working this morning!

I need to create a line chart that shows the attendance of a department over days and time.

The data currently looks like this:

Picture1.png

I had wanted to have the date as a dimension across the bottom but couldn't then work out how to show the numbers in the department on the times during that day. I assume i'll need two dimensions but wasn't quite sure how to do it.

 

Thanks,

Peter

2 Replies
Highlighted
Creator II
Creator II

Wanted to be able to produce something similar to this (but obviously prettier):

Picture2.png

Highlighted
Creator II
Creator II

Does anybody have any suggestions for this?

The best I could do was create a datestamp column in the original data by combing the date and time and then plotting that as the dimension however it looks very messy. (I've done it a as a bar graph in this instance but bar or line is irrelevant) 

1.png