topic Re: Line/Bar Chart with two dimensions in QlikView

Line/Bar Chart with two dimensions

Mon, 16 Jun 2014 10:19:38 GMT

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

Re: Line/Bar Chart with two dimensions

datanibbler — Mon, 16 Jun 2014 10:41:13 GMT

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

Re: Line/Bar Chart with two dimensions

Mon, 16 Jun 2014 10:51:26 GMT

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

Re: Line/Bar Chart with two dimensions

Mon, 16 Jun 2014 11:09:47 GMT

Hi ,

Can you please provide the some dummy data and the output you needed.

like rough figure .

Thanks

Yusuf

Re: Line/Bar Chart with two dimensions

Mon, 16 Jun 2014 11:20:11 GMT

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

Re: Line/Bar Chart with two dimensions

Mon, 16 Jun 2014 14:16:54 GMT

Any idea YUSUF ALI?

Re: Line/Bar Chart with two dimensions

Anonymous — Mon, 16 Jun 2014 14:18:19 GMT

can you attach the sample app?

Re: Line/Bar Chart with two dimensions

Mon, 16 Jun 2014 14:22:27 GMT

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!

Re: Line/Bar Chart with two dimensions

Anonymous — Mon, 16 Jun 2014 14:28:26 GMT

you can add a second dimension which will automatically displays the second chart.

Try and send me the image if that doesn't work

Re: Line/Bar Chart with two dimensions

Mon, 16 Jun 2014 14:32:47 GMT

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.

Re: Line/Bar Chart with two dimensions

Anonymous — Mon, 16 Jun 2014 14:35:26 GMT

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

Re: Line/Bar Chart with two dimensions

Mon, 16 Jun 2014 14:38:29 GMT

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.

Re: Line/Bar Chart with two dimensions

thomduvi83 — Mon, 16 Jun 2014 14:39:19 GMT

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.

Re: Line/Bar Chart with two dimensions

Mon, 16 Jun 2014 14:44:06 GMT

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