topic Re: Creating one chart with two sources in QlikView https://community.qlik.com/t5/QlikView/Creating-one-chart-with-two-sources/m-p/721011#M258954 <HTML><HEAD></HEAD><BODY><P>This looks okay so far. Let me try with my data set. </P><P></P><P>Is there anyway we could connect the actual sales line and forecast line?</P></BODY></HTML> Mon, 29 Sep 2014 19:16:54 GMT 2014-09-29T19:16:54Z Creating one chart with two sources https://community.qlik.com/t5/QlikView/Creating-one-chart-with-two-sources/m-p/721009#M258952 <HTML><HEAD></HEAD><BODY><P>I have actual sales from weeks before in sheet 1 of the excel spreadsheet and I have forecast for the next 20 weeks in the excel spreadsheet. I want to create a line graph that shows me 4 weeks of actual sales from current week and 13 weeks of future forecast.</P><P>So if current week was 201410, I want to see a line graph that shows me sales for 201409,201408, 201407, 201406.</P><P></P><P>Then I want the line to continue into the forecast... so it should show the forecast for weeks 201410 all the way until 201422.&nbsp; </P><P></P><P></P><P><SPAN style="font-size: 13.63636302948px;">Please see my QVW example. </SPAN></P></BODY></HTML> Mon, 29 Sep 2014 18:52:11 GMT https://community.qlik.com/t5/QlikView/Creating-one-chart-with-two-sources/m-p/721009#M258952 2014-09-29T18:52:11Z Re: Creating one chart with two sources https://community.qlik.com/t5/QlikView/Creating-one-chart-with-two-sources/m-p/721010#M258953 <HTML><HEAD></HEAD><BODY><P>hi&nbsp; have a look at the attach example </P></BODY></HTML> Mon, 29 Sep 2014 19:01:39 GMT https://community.qlik.com/t5/QlikView/Creating-one-chart-with-two-sources/m-p/721010#M258953 lironbaram 2014-09-29T19:01:39Z Re: Creating one chart with two sources https://community.qlik.com/t5/QlikView/Creating-one-chart-with-two-sources/m-p/721011#M258954 <HTML><HEAD></HEAD><BODY><P>This looks okay so far. Let me try with my data set. </P><P></P><P>Is there anyway we could connect the actual sales line and forecast line?</P></BODY></HTML> Mon, 29 Sep 2014 19:16:54 GMT https://community.qlik.com/t5/QlikView/Creating-one-chart-with-two-sources/m-p/721011#M258954 2014-09-29T19:16:54Z Re: Creating one chart with two sources https://community.qlik.com/t5/QlikView/Creating-one-chart-with-two-sources/m-p/721012#M258955 <HTML><HEAD></HEAD><BODY><P>hi have a look at this</P></BODY></HTML> Mon, 29 Sep 2014 20:21:27 GMT https://community.qlik.com/t5/QlikView/Creating-one-chart-with-two-sources/m-p/721012#M258955 lironbaram 2014-09-29T20:21:27Z