Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
send me the current image,without that it will be difficult for us to solve your query
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.
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.
Thanks Thomas, kind of guessed I would have to go down that route. Will make a few changes then!