Line/Bar Chart with two dimensions

[#1]

Hi,

I have data of the following format:

ID	Receipt Time Interval	Send Time Interval
1	16:00	17:30
2	15:00	16:00
3	11:00	14:30
4	18:00	18:15

I want to display the time intervals on X, the counts per interval on Y on a line chart.

Time intervals on X and EITHER receipt or send count on Y is easy - but how do I get TWO LINES in there, one per dimension?

Bar chart would be fine as well!

Thank you!
Oli

[Anonymous]

send me the current image,without that it will be difficult for us to solve your query

[#3]

I can't send anything. I need to procude something like the image above, it's probably not even possible in QlikView. Will just have to do it in Excel I guess.

[thomduvi83 · Accepted solution]

You don't have two dimensions (only time), but two expressions (count of sent & received)

Prepare a bit the data in the model to have something like this :

Time	ID Sent	ID Received
16:00	1	-
16:00	-	2
17:30	-	1
18:00	4	-
...

with something like :

LOAD Receipt_Time as Time, ID as Receipt_ID RESIDENT MyTable

CONCATENATE LOAD Send_Time as Time, ID as Send_ID RESIDENT MyTable

After that it will be easy to produce your graph.

[#5]

Thanks Thomas, kind of guessed I would have to go down that route. Will make a few changes then!