Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
Margaret
Contributor II

predict annualized turnover

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?

TurnoverBarChart.JPG

1 Solution

Accepted Solutions

Re: predict annualized turnover

Is this what you want?

Capture.PNG

View solution in original post

2 Replies

Re: predict annualized turnover

Is this what you want?

Capture.PNG

View solution in original post

Margaret
Contributor II

Re: predict annualized turnover

Yes. You are my hero!