topic Re: predict annualized turnover in QlikView https://community.qlik.com/t5/QlikView/predict-annualized-turnover/m-p/54392#M511159 <HTML><HEAD></HEAD><BODY><P>Yes. You are my hero!</P></BODY></HTML> Tue, 05 Jun 2018 14:55:56 GMT Margaret 2018-06-05T14:55:56Z predict annualized turnover https://community.qlik.com/t5/QlikView/predict-annualized-turnover/m-p/54390#M511157 <HTML><HEAD></HEAD><BODY><P>I created a bar graph depicting accumulated % Employee (in this case, Registered Nurses (RN's)) Turnover for this year. I want to predict it for the rest of the year. I've added values for the rest of the months of this year and a Trendline that works as a prediction (I think?). But I don't want any bars corresponding to those months (because we don't know the actual Turnover for those months yet) i.e., I want the bars for months 5-12 here (and the % values on them), to disappear--and I don't want those values effecting the Trendline. I want the Trendline extend into the future based on the months that I have real data for. I've also attached a qvw. How can I do this?</P><P></P><P><IMG __jive_id="204308" alt="TurnoverBarChart.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/204308_TurnoverBarChart.JPG" style="height: 304px; width: 620px;" /></P></BODY></HTML> Mon, 04 Jun 2018 20:56:51 GMT https://community.qlik.com/t5/QlikView/predict-annualized-turnover/m-p/54390#M511157 Margaret 2018-06-04T20:56:51Z Re: predict annualized turnover https://community.qlik.com/t5/QlikView/predict-annualized-turnover/m-p/54391#M511158 <HTML><HEAD></HEAD><BODY><P>Is this what you want?</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/204317_Capture.PNG" style="height: 300px; width: 620px;" /></P></BODY></HTML> Tue, 05 Jun 2018 00:38:13 GMT https://community.qlik.com/t5/QlikView/predict-annualized-turnover/m-p/54391#M511158 sunny_talwar 2018-06-05T00:38:13Z Re: predict annualized turnover https://community.qlik.com/t5/QlikView/predict-annualized-turnover/m-p/54392#M511159 <HTML><HEAD></HEAD><BODY><P>Yes. You are my hero!</P></BODY></HTML> Tue, 05 Jun 2018 14:55:56 GMT https://community.qlik.com/t5/QlikView/predict-annualized-turnover/m-p/54392#M511159 Margaret 2018-06-05T14:55:56Z