topic Line chart with two dimensions in one in QlikView https://community.qlik.com/t5/QlikView/Line-chart-with-two-dimensions-in-one/m-p/854981#M299717 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P></P><P>I am trying to create a plot similar to the one displayed below, but with two lines. On the x axis, I would like to have one single dimension, representing the time of the day (in hours, from 0 to 23).</P><P>The aim of the plot is to show the number of people who arrive to the hospital by hour, and the number of people who leave the hospital by hour. One line for each.</P><P></P><P>So, should I have one single dimension for both, or separated dimensions?</P><P></P><P>Any ideas?</P><P></P><P>Thanks in advance.</P><P>Cheers,</P><P></P><P>Ines<IMG __jive_id="91370" alt="plot.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/91370_plot.PNG" style="height: 184px; width: 620px;" /></P></BODY></HTML> Tue, 30 Jun 2015 15:06:56 GMT inescastelhano 2015-06-30T15:06:56Z Line chart with two dimensions in one https://community.qlik.com/t5/QlikView/Line-chart-with-two-dimensions-in-one/m-p/854981#M299717 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P></P><P>I am trying to create a plot similar to the one displayed below, but with two lines. On the x axis, I would like to have one single dimension, representing the time of the day (in hours, from 0 to 23).</P><P>The aim of the plot is to show the number of people who arrive to the hospital by hour, and the number of people who leave the hospital by hour. One line for each.</P><P></P><P>So, should I have one single dimension for both, or separated dimensions?</P><P></P><P>Any ideas?</P><P></P><P>Thanks in advance.</P><P>Cheers,</P><P></P><P>Ines<IMG __jive_id="91370" alt="plot.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/91370_plot.PNG" style="height: 184px; width: 620px;" /></P></BODY></HTML> Tue, 30 Jun 2015 15:06:56 GMT https://community.qlik.com/t5/QlikView/Line-chart-with-two-dimensions-in-one/m-p/854981#M299717 inescastelhano 2015-06-30T15:06:56Z Re: Line chart with two dimensions in one https://community.qlik.com/t5/QlikView/Line-chart-with-two-dimensions-in-one/m-p/854982#M299718 <HTML><HEAD></HEAD><BODY><P>I would go for one dimension and two expressions.</P></BODY></HTML> Tue, 30 Jun 2015 15:08:33 GMT https://community.qlik.com/t5/QlikView/Line-chart-with-two-dimensions-in-one/m-p/854982#M299718 Anonymous 2015-06-30T15:08:33Z Re: Line chart with two dimensions in one https://community.qlik.com/t5/QlikView/Line-chart-with-two-dimensions-in-one/m-p/854983#M299719 <HTML><HEAD></HEAD><BODY><P>The problem is that I load two separate fields from the fact table. How can I merge them into one and associate the number of people?</P></BODY></HTML> Tue, 30 Jun 2015 15:14:27 GMT https://community.qlik.com/t5/QlikView/Line-chart-with-two-dimensions-in-one/m-p/854983#M299719 inescastelhano 2015-06-30T15:14:27Z Re: Line chart with two dimensions in one https://community.qlik.com/t5/QlikView/Line-chart-with-two-dimensions-in-one/m-p/854984#M299720 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>If you share some sample data or application then it would be easier to solve.&nbsp; I think for this scenario you can use Hour as dimension and two expressions like </P><P></P><P>Sum(PatientsArrived)</P><P>Sum(PatientsLeft)</P><P></P><P>Regards,</P><P>Jagan.</P></BODY></HTML> Tue, 30 Jun 2015 15:18:01 GMT https://community.qlik.com/t5/QlikView/Line-chart-with-two-dimensions-in-one/m-p/854984#M299720 jagan 2015-06-30T15:18:01Z Re: Line chart with two dimensions in one https://community.qlik.com/t5/QlikView/Line-chart-with-two-dimensions-in-one/m-p/854985#M299721 <HTML><HEAD></HEAD><BODY><P>with two seperate fields I guess you mean arrival and leaving timestamps.</P><P>You could solve this by creating a canonical date (or in this case time):</P><P></P><P><A href="https://community.qlik.com/qlik-blogpost/3585">Canonical Date</A></P><P></P><P>hope this helps</P><P></P><P>regards</P><P></P><P>Marco</P></BODY></HTML> Tue, 30 Jun 2015 15:26:23 GMT https://community.qlik.com/t5/QlikView/Line-chart-with-two-dimensions-in-one/m-p/854985#M299721 MarcoWedel 2015-06-30T15:26:23Z Re: Line chart with two dimensions in one https://community.qlik.com/t5/QlikView/Line-chart-with-two-dimensions-in-one/m-p/854986#M299722 <HTML><HEAD></HEAD><BODY><P>one dimension as hour on ur x-axis</P><P>and two expressions</P><P>one for <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">number of people who arrive to the hospital by hour</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">second for <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">number of people who leave the hospital by hour</SPAN></SPAN></P></BODY></HTML> Tue, 30 Jun 2015 15:50:45 GMT https://community.qlik.com/t5/QlikView/Line-chart-with-two-dimensions-in-one/m-p/854986#M299722 buzzy996 2015-06-30T15:50:45Z Re: Line chart with two dimensions in one https://community.qlik.com/t5/QlikView/Line-chart-with-two-dimensions-in-one/m-p/854987#M299723 <HTML><HEAD></HEAD><BODY><P>Thank you <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /> seems like something I could use. I will try to understand it. </P></BODY></HTML> Tue, 30 Jun 2015 15:57:51 GMT https://community.qlik.com/t5/QlikView/Line-chart-with-two-dimensions-in-one/m-p/854987#M299723 inescastelhano 2015-06-30T15:57:51Z Re: Line chart with two dimensions in one https://community.qlik.com/t5/QlikView/Line-chart-with-two-dimensions-in-one/m-p/854988#M299724 <HTML><HEAD></HEAD><BODY><P>Sorry, The example I provided was not correct. Here follows the correct one.</P></BODY></HTML> Tue, 30 Jun 2015 16:02:04 GMT https://community.qlik.com/t5/QlikView/Line-chart-with-two-dimensions-in-one/m-p/854988#M299724 inescastelhano 2015-06-30T16:02:04Z Re: Line chart with two dimensions in one https://community.qlik.com/t5/QlikView/Line-chart-with-two-dimensions-in-one/m-p/854989#M299725 <HTML><HEAD></HEAD><BODY><P>Inês</P><P></P><P>See Attached.</P><P></P><P>I did a Binary Load off your qvw to rejig your data model.</P></BODY></HTML> Tue, 30 Jun 2015 16:32:05 GMT https://community.qlik.com/t5/QlikView/Line-chart-with-two-dimensions-in-one/m-p/854989#M299725 Anonymous 2015-06-30T16:32:05Z Re: Line chart with two dimensions in one https://community.qlik.com/t5/QlikView/Line-chart-with-two-dimensions-in-one/m-p/854990#M299726 <HTML><HEAD></HEAD><BODY><P>Took me a bit to understand, but it works ! Thank you!</P></BODY></HTML> Tue, 30 Jun 2015 16:37:37 GMT https://community.qlik.com/t5/QlikView/Line-chart-with-two-dimensions-in-one/m-p/854990#M299726 inescastelhano 2015-06-30T16:37:37Z Re: Line chart with two dimensions in one https://community.qlik.com/t5/QlikView/Line-chart-with-two-dimensions-in-one/m-p/854991#M299727 <HTML><HEAD></HEAD><BODY><P>glad it helped</P><P></P><P>regards</P><P></P><P>Marco</P></BODY></HTML> Tue, 30 Jun 2015 18:02:38 GMT https://community.qlik.com/t5/QlikView/Line-chart-with-two-dimensions-in-one/m-p/854991#M299727 MarcoWedel 2015-06-30T18:02:38Z