topic Re: Forecast Data help please! in QlikView https://community.qlik.com/t5/QlikView/Forecast-Data-help-please/m-p/697181#M1067363 <HTML><HEAD></HEAD><BODY><P>Hi Gysbert</P><P></P><P>Thanks again for the example you very kindly gave me this morning.&nbsp; Would it be possible for you to tell me how to left justify the monthyear column within the load ?</P><P></P><P>Thank you <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Wed, 03 Sep 2014 12:31:13 GMT 2014-09-03T12:31:13Z Forecast Data help please! https://community.qlik.com/t5/QlikView/Forecast-Data-help-please/m-p/697178#M1067357 <HTML><HEAD></HEAD><BODY><P>Hi all</P><P></P><P>I'm a newbie that could really do with some assistance.&nbsp; The data I have available to me is as follows:</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 457px; color: rgb(34, 34, 34); text-indent: 0px;"><TBODY><TR><TD height="17" style="font-family: arial, sans-serif;" width="48">Project</TD><TD style="font-family: arial, sans-serif; border-left-style: none;" width="152">Anticipated Launch date</TD><TD style="font-family: arial, sans-serif; border-left-style: none;" width="164">Expected 3 Year Sales Value</TD><TD style="font-family: arial, sans-serif; border-left-style: none;" width="93">PeriodValue</TD></TR><TR><TD height="17" style="font-family: arial, sans-serif; border-top-style: none;">P1</TD><TD style="font-family: arial, sans-serif; border-top-style: none; border-left-style: none;">01/06/2014</TD><TD style="font-family: arial, sans-serif; border-top-style: none; border-left-style: none;">50000.00</TD><TD align="right" style="font-family: arial, sans-serif; border-top-style: none; border-left-style: none;">1388.888889</TD></TR><TR><TD height="17" style="font-family: arial, sans-serif; border-top-style: none;">P2</TD><TD style="font-family: arial, sans-serif; border-top-style: none; border-left-style: none;">01/07/2014</TD><TD style="font-family: arial, sans-serif; border-top-style: none; border-left-style: none;">50000.00</TD><TD align="right" style="font-family: arial, sans-serif; border-top-style: none; border-left-style: none;">1388.888889</TD></TR><TR><TD height="17" style="font-family: arial, sans-serif; border-top-style: none;">P3</TD><TD style="font-family: arial, sans-serif; border-top-style: none; border-left-style: none;">01/07/2014</TD><TD style="font-family: arial, sans-serif; border-top-style: none; border-left-style: none;">50000.00</TD><TD align="right" style="font-family: arial, sans-serif; border-top-style: none; border-left-style: none;">1388.888889</TD></TR><TR><TD height="17" style="font-family: arial, sans-serif; border-top-style: none;">P4</TD><TD style="font-family: arial, sans-serif; border-top-style: none; border-left-style: none;">01/08/2014</TD><TD style="font-family: arial, sans-serif; border-top-style: none; border-left-style: none;">40000</TD><TD align="right" style="font-family: arial, sans-serif; border-top-style: none; border-left-style: none;">1111.111111</TD></TR><TR><TD height="17" style="font-family: arial, sans-serif; border-top-style: none;">P5</TD><TD style="font-family: arial, sans-serif; border-top-style: none; border-left-style: none;">01/10/2014</TD><TD style="font-family: arial, sans-serif; border-top-style: none; border-left-style: none;">5000</TD><TD align="right" style="font-family: arial, sans-serif; border-top-style: none; border-left-style: none;">138.8888889</TD></TR></TBODY></TABLE><P></P><P></P><P>I want to bar chart in qlikview that plots the period value across 36 months from the 'Anticipated launch date'</P><P>eg&nbsp; every month from 01/06/2014 plot £1388. every month from 01/07/2014 plot £1388 and so on.</P><P></P><P>Any help will be greatly appreciated.</P></BODY></HTML> Wed, 03 Sep 2014 08:26:37 GMT https://community.qlik.com/t5/QlikView/Forecast-Data-help-please/m-p/697178#M1067357 2014-09-03T08:26:37Z Re: Forecast Data help please! https://community.qlik.com/t5/QlikView/Forecast-Data-help-please/m-p/697179#M1067359 <HTML><HEAD></HEAD><BODY><P>See attached qvw</P></BODY></HTML> Wed, 03 Sep 2014 09:28:40 GMT https://community.qlik.com/t5/QlikView/Forecast-Data-help-please/m-p/697179#M1067359 Gysbert_Wassenaar 2014-09-03T09:28:40Z Re: Forecast Data help please! https://community.qlik.com/t5/QlikView/Forecast-Data-help-please/m-p/697180#M1067361 <HTML><HEAD></HEAD><BODY><P>Thank you very much Gysbert.&nbsp; Works perfectly <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Wed, 03 Sep 2014 09:33:02 GMT https://community.qlik.com/t5/QlikView/Forecast-Data-help-please/m-p/697180#M1067361 2014-09-03T09:33:02Z Re: Forecast Data help please! https://community.qlik.com/t5/QlikView/Forecast-Data-help-please/m-p/697181#M1067363 <HTML><HEAD></HEAD><BODY><P>Hi Gysbert</P><P></P><P>Thanks again for the example you very kindly gave me this morning.&nbsp; Would it be possible for you to tell me how to left justify the monthyear column within the load ?</P><P></P><P>Thank you <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Wed, 03 Sep 2014 12:31:13 GMT https://community.qlik.com/t5/QlikView/Forecast-Data-help-please/m-p/697181#M1067363 2014-09-03T12:31:13Z Re: Forecast Data help please! https://community.qlik.com/t5/QlikView/Forecast-Data-help-please/m-p/697182#M1067364 <HTML><HEAD></HEAD><BODY><P>Left justify sounds like a layout change, not data processing. That's something that cannot be done in the load script. You'll need to set that on the Presentation tab of the table box or chart object.</P></BODY></HTML> Wed, 03 Sep 2014 12:51:03 GMT https://community.qlik.com/t5/QlikView/Forecast-Data-help-please/m-p/697182#M1067364 Gysbert_Wassenaar 2014-09-03T12:51:03Z