This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
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 :
1. Labour Cost per Total Employee.
2. Labour Cost per Full Time Employee
3. Labour Cost per Part Time Employee
Thank you so much
Like attached qvw?
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
May be like this.
Make sure you have proper Calculation.
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]';