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
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.
Hi 46457686,
there are several possibilities.
- With a barchart (or combochart, which is basically the same thing), you CAN use two dimensions - but that will result in the graph being a bit confusing.
- You can activate the TRELLIS option on one of the dimensions (the one on top in the dialog), which will give you two smaller charts in the space otherwise occupied by one.
HTH
Best regards,
DataNibbler
Hi,
Thanks for your answer. This isn't really giving me what I want - I need the time (00:00-23:59) on X, the count on Y and two lines or two sets of bars in different colours.
Using two dimensions in a combo chart only shows the dimension that is promoted higher.
Surely there must a way for such a basic functionality really?
Thanks!
Oli
Hi ,
Can you please provide the some dummy data and the output you needed.
like rough figure .
Thanks
Yusuf
Hi Yusuf,
I need something like this: Blue is what I already have in QlikView, but Red is what I need to add (another dimension with the same time scale of 24 hours on X).
Sample data is my table above for example. Just ID, Receipt Time, Send time.
Thanks!
Oli
Any idea YUSUF ALI?
can you attach the sample app?
Sorry I can't due to sensitive nature of the data. However, you literally only need a few random entries for RECEIPT and SEND and try and display both in the same chart...
Thanks!
you can add a second dimension which will automatically displays the second chart.
Try and send me the image if that doesn't work
Adding a second dimension just stacks that one onto the existing first dimension bars, as opposed to displaying new bars... I need both dimensions to be on the same level, and not one stacked into the other.