topic Re: re: labels on the axis of a forecast? in QlikView https://community.qlik.com/t5/QlikView/re-labels-on-the-axis-of-a-forecast/m-p/1373659#M419538 <HTML><HEAD></HEAD><BODY><P>As per thread. Text in the chart works to my satisfaction. All done now. Thanks everyone! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Sun, 12 Nov 2017 13:53:40 GMT Anonymous 2017-11-12T13:53:40Z re: labels on the axis of a forecast? https://community.qlik.com/t5/QlikView/re-labels-on-the-axis-of-a-forecast/m-p/1373653#M419532 <HTML><HEAD></HEAD><BODY><P>I've added a forecast value of three on the axis tab of chart properties:</P><P></P><P><IMG __jive_id="182947" alt="GP_Prescribing_NHS_Wales_Demo_v1_Screenshot_Axes_ForecastOption.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/182947_GP_Prescribing_NHS_Wales_Demo_v1_Screenshot_Axes_ForecastOption.png" style="height: 531px; width: 620px;" /></P><P></P><P>and was wondering if there is any way to get some labels on the x-axis after the dates eg: forecastdate1, <SPAN style="font-size: 13.3333px;">forecastdate2 etc..</SPAN></P><P></P><P><IMG alt="GP_Prescribing_NHS_Wales_Demo_v1_Screenshot.png" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/182949_GP_Prescribing_NHS_Wales_Demo_v1_Screenshot.png" style="height: 383px; width: 620px;" /></P></BODY></HTML> Sun, 12 Nov 2017 01:42:31 GMT https://community.qlik.com/t5/QlikView/re-labels-on-the-axis-of-a-forecast/m-p/1373653#M419532 Anonymous 2017-11-12T01:42:31Z Re: re: labels on the axis of a forecast? https://community.qlik.com/t5/QlikView/re-labels-on-the-axis-of-a-forecast/m-p/1373654#M419533 <HTML><HEAD></HEAD><BODY><P>There is no way, But we can add using Island table that necessary to use from reference of island field and which occurs to forecast using Linest_M and Linest_B ..</P></BODY></HTML> Sun, 12 Nov 2017 05:55:54 GMT https://community.qlik.com/t5/QlikView/re-labels-on-the-axis-of-a-forecast/m-p/1373654#M419533 Anil_Babu_Samineni 2017-11-12T05:55:54Z Re: re: labels on the axis of a forecast? https://community.qlik.com/t5/QlikView/re-labels-on-the-axis-of-a-forecast/m-p/1373655#M419534 <HTML><HEAD></HEAD><BODY><P>Do you have an example?</P></BODY></HTML> Sun, 12 Nov 2017 13:02:39 GMT https://community.qlik.com/t5/QlikView/re-labels-on-the-axis-of-a-forecast/m-p/1373655#M419534 Anonymous 2017-11-12T13:02:39Z Re: re: labels on the axis of a forecast? https://community.qlik.com/t5/QlikView/re-labels-on-the-axis-of-a-forecast/m-p/1373656#M419535 <HTML><HEAD></HEAD><BODY><P>There's no inherent way, but there's a workaround you can try and use.</P><P>Under "Presentation", add reference text. Enter a formula for the next period (in your case, it would probably be Max(Period)+100). Format it as desired. Using CTRL+SHIFT, drag it to the right side and place it where the label would normally go. Repeat the process for the number of forecast periods you plan to enable. </P></BODY></HTML> Sun, 12 Nov 2017 13:18:14 GMT https://community.qlik.com/t5/QlikView/re-labels-on-the-axis-of-a-forecast/m-p/1373656#M419535 Or 2017-11-12T13:18:14Z Re: re: labels on the axis of a forecast? https://community.qlik.com/t5/QlikView/re-labels-on-the-axis-of-a-forecast/m-p/1373657#M419536 <HTML><HEAD></HEAD><BODY><P>I see! Label dragging. Crude workaround. Thanks! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/laugh.png" /></P><P></P><P><IMG alt="floating_text.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/182975_floating_text.png" style="height: 321px; width: 620px;" /></P></BODY></HTML> Sun, 12 Nov 2017 13:43:58 GMT https://community.qlik.com/t5/QlikView/re-labels-on-the-axis-of-a-forecast/m-p/1373657#M419536 Anonymous 2017-11-12T13:43:58Z Re: re: labels on the axis of a forecast? https://community.qlik.com/t5/QlikView/re-labels-on-the-axis-of-a-forecast/m-p/1373658#M419537 <HTML><HEAD></HEAD><BODY><P>Please attach you application to investigate. And make sure to add inline to reload an Island table.</P><P></P><P>And, As work around requested - Try to use "<STRONG>Text in Chart</STRONG>" option from presentation tab of each line if report got constant.</P></BODY></HTML> Sun, 12 Nov 2017 13:50:46 GMT https://community.qlik.com/t5/QlikView/re-labels-on-the-axis-of-a-forecast/m-p/1373658#M419537 Anil_Babu_Samineni 2017-11-12T13:50:46Z Re: re: labels on the axis of a forecast? https://community.qlik.com/t5/QlikView/re-labels-on-the-axis-of-a-forecast/m-p/1373659#M419538 <HTML><HEAD></HEAD><BODY><P>As per thread. Text in the chart works to my satisfaction. All done now. Thanks everyone! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Sun, 12 Nov 2017 13:53:40 GMT https://community.qlik.com/t5/QlikView/re-labels-on-the-axis-of-a-forecast/m-p/1373659#M419538 Anonymous 2017-11-12T13:53:40Z Re: re: labels on the axis of a forecast? https://community.qlik.com/t5/QlikView/re-labels-on-the-axis-of-a-forecast/m-p/1373660#M419539 <HTML><HEAD></HEAD><BODY><P>I even wonder, How Customer satisfy this review because It may change some where in filter and it compulsi to compute each. And here not sure how they know which is forecast and which is normal data set. Are you going to change any text color? If so, That could be make sense.</P></BODY></HTML> Sun, 12 Nov 2017 13:58:05 GMT https://community.qlik.com/t5/QlikView/re-labels-on-the-axis-of-a-forecast/m-p/1373660#M419539 Anil_Babu_Samineni 2017-11-12T13:58:05Z Re: re: labels on the axis of a forecast? https://community.qlik.com/t5/QlikView/re-labels-on-the-axis-of-a-forecast/m-p/1373661#M419540 <HTML><HEAD></HEAD><BODY><P>That is a good point about the line colour. They will know because the verbal commentary will state from which month the forecast begins... <IMG src="https://community.qlik.com/legacyfs/online/emoticons/silly.png" /></P></BODY></HTML> Mon, 13 Nov 2017 11:37:30 GMT https://community.qlik.com/t5/QlikView/re-labels-on-the-axis-of-a-forecast/m-p/1373661#M419540 Anonymous 2017-11-13T11:37:30Z