Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
tracycrown
Creator III
Creator III

Compute Variable KPIs

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

1 Solution

Accepted Solutions
tresesco
MVP
MVP

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).

View solution in original post

3 Replies
tresesco
MVP
MVP

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).

View solution in original post

ashfaq_haseeb

Hi,

May be like this.

Make sure you have proper Calculation.

Regards

ASHFAQ

tracycrown
Creator III
Creator III
Author

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