topic Re: Compute Variable KPIs in QlikView

Compute Variable KPIs

tracycrown — Mon, 01 Sep 2014 10:53:47 GMT

Dear all

I have no problem to load data in Table 1 but do not know how to compute variable KPIs in Table 2.

My expected answer is stated in the attached worksheet :

Variable KPIs

1. Labour Cost per Total Employee.

2. Labour Cost per Full Time Employee

3. Labour Cost per Part Time Employee

Thank you so much

Tracy

Re: Compute Variable KPIs

tresB — Mon, 01 Sep 2014 11:01:55 GMT

Like attached qvw?

Dimension: Year

Then pull across dimension to columns(right->top) and then expression to rows(left->down). And yes expression would be better with set analysis rather than IF (i have shown for first expression).

Re: Compute Variable KPIs

ashfaq_haseeb — Mon, 01 Sep 2014 11:08:29 GMT

Hi,

May be like this.

Make sure you have proper Calculation.

Regards

ASHFAQ

Re: Compute Variable KPIs

tracycrown — Mon, 01 Sep 2014 16:25:24 GMT

Der Tresesco

Many thanks for your help, the answer is correct.

IF is not the better method, then can you show me an example on what you described in your advice.

Also if possible, can you also explain or give example on using the following method:

set vLabHC = '($(vLabCost))/($(vHC))';

Set vHC = 'Employee';

Set vLabCost = '[Labour Cost]';

Many Thanks

Tracy