topic Re: Line chart with times and dates in QlikView

Line chart with times and dates

peterderrington — Wed, 25 Nov 2020 16:16:04 GMT

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:

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

Re: Line chart with times and dates

peterderrington — Mon, 17 Feb 2020 11:24:57 GMT

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

Re: Line chart with times and dates

peterderrington — Tue, 25 Feb 2020 09:06:36 GMT

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)