Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
Margaret
Creator II
Creator 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
sunny_talwar

Is this what you want?

Capture.PNG

View solution in original post

2 Replies
sunny_talwar

Is this what you want?

Capture.PNG

Margaret
Creator II
Creator II
Author

Yes. You are my hero!