This demo manages employees FTE (Full Time Equivalent) by month and yearly pay increase, variable and bonus. The grid is filtered by Division to select the employees.
The user can input the FTE forecast by cells or use Smart Data Entry to copy from the initial FTE budget with a multiplier. The Gross Salary total is impacted by the FTE.
The pay increase is limited by a threshold set in the Qlik® document.
The bonus calculation spreads the global bonus set in the Qlik® document, split by employee according to excel formulas live in the grid. The proposed bonus may be over-assigned in the next column.
The forecast input will not be saved until the over-assigned bonus respect the global bonus and if the global reforecast exceeds the initial global budget (validation rule).
All inputted cells and formula calculations are saved to the SQL buffer tables, ready to be exported in the enterprise database.
A mix of QlikView® and Qlik Sense® users can share the same application contributing to the same database: