Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
Not applicable

Headcount Forecast

fture.png

I got the above figured out... but not the following.. can someone help pls?

basically-- I have the Active Headcount for Match as well as Future Joiners/Leavers/Open roles for the next 12 or so months.. and from that create a forecast

Active Next Month = Active This Month+Future Joiners+Open Roles- Future Leavers

and as attached is my qvw

Headcount
  Drivers
MarAprMayJunJulAugSepOctNovDecJanFebMarAprMay
Active This Month140114011369134113331326132913381342134613511368136913701371
Future Joiners000000045171111
Future Leavers3228870000000000
Open Roles00003940000000
Active Next Month140113691341133313261329133813421346135113681369137013711372
1 Reply
Highlighted
Not applicable

Re: Headcount Forecast

here is my qvw