topic Re: How to calculate a turnover in QlikView

How to calculate a turnover

Tue, 06 Jan 2015 09:14:30 GMT

Hi Everyone,

I have a table like below and I want to calculate the turnover of ACTORID per period. (ACTORID is the name of the employees)

So I want to do a bar chart with month in dimension for exemple and the turnover in the expression.

Could any one help me please? Thanks you.

ACTORID	Period
BBT	40909
BBT	40940
BBT	40969
BMS	40909
BMS	40940
BMS	40969
BPI	40909
BPI	40940
BPI	40969
BSK	40909
BSK	40940
BSK	40969
CAN	40909
CAN	40940
CAN	40969
CCN	40909
CCN	40940
CCN	40969
CDR	40969
DCE	40909
DCE	40940
DCE	40969
DCS	40909
DCS	40940
DCS	40969
FVS	40940
HES	40940
HSN	40909
HSN	40940
HSN	40969
IJS	40909
IJS	40940
IJS	40969
ISS	40909
ISS	40940
ISS	40969
KRS	40909
KRS	40940
KRS	40969
KWS	40909
KWS	40940
KWS	40969
LLS	40909
LLS	40940
LLS	40969
MLT	40909
MLT	40940
MLT	40969
MSN	40940
MSN	40969
NSN	40909
NSN	40940
NSN	40969

Re: How to calculate a turnover

its_anandrjs — Tue, 06 Jan 2015 09:18:55 GMT

Hi,

In load script make change like

LOAD

ACTORID,

Period,

Month(Date(Period)) as Month,

Date(Period) as Date

From Source;

Regards

Anand

Re: How to calculate a turnover

Tue, 06 Jan 2015 09:26:54 GMT

Hi Ben,

have a look at the attached, should give you an idea of how to do this

hope that helps

Joe

Re: How to calculate a turnover

Tue, 06 Jan 2015 09:34:31 GMT

Ok thank you for theses ansewers but i look for the formula of turnover. I have only these datas and i want to know when how much employees get in and how much get out.

Re: How to calculate a turnover

Tue, 06 Jan 2015 09:38:27 GMT

you only have those two fields? You'll need some fact data in order to calculate anything (in my example I added a value field for instance).

Re: How to calculate a turnover

Tue, 06 Jan 2015 09:43:03 GMT

Yes I have only those two fields. The period is a date when the ACTORID have worked. So With these date i want to deduct the time when he came in the company and when he left and count them, to calculate the turnover.

Re: How to calculate a turnover

Tue, 06 Jan 2015 11:21:46 GMT

Not sure I follow what you are trying to calculate, this is staff turnover you are looking for? How would you determine when an employee joined and left?

Re: How to calculate a turnover

consenit — Tue, 06 Jan 2015 12:23:46 GMT

Hi there.

Assuming that for each employee the minimum date is the date joined, and the maximum date is the date left, you can use calculated dimensions:

=DATE(AGGR(MIN(Period), ACTORID))

and:

=DATE(AGGR(MAX(Period), ACTORID))

See example attached.

Kind regards,

Ernesto.