Discussion Board for collaboration related to QlikView App Development.
Pls help below scenario
From the given data source (HeadcountDataSource.qvd), please transform the data into a structure described in table Output. Details per following:
Data Source Description
Cost center code
Actuality of the values e.g. Actual (AC), Budget (BU), Forecast (FC) figures
Date representing Year and Month of data, data format is yyyy-mm-01
Number of employees (Monthly) of corresponding CompanyCode, CostCenter, Period, and Actuality
An average number of employees per month from the beginning of year until the month (month value in KPI_PERIOD column)
This will help:
Hi Sergey,thanks for your kind revert.
But it doesn't giving proper answer with rangeavg function.
Kinly recheck as per data mentioned and do the needful.
Can you please provide more expanded answer? I'm don't getting what is wrong...
The result is VALUEYTD it brings an average of epmloyees from 1st month to the end of the year.