Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Row Sub Totals PIVOT are incorrect

Hi

I am trying to set up pivot calculation for employees with salary broken into Base and Allowances.  Base is set f/nightly amount while allowances are dependent on hours contracted (the allowances amount requires prorata amount to be applied.  I can get the calculation to perform correctly however the subtotals for each employee tally the base amount plus full time allowance amount.

Essentially the total for this example should be 1425.63 not 1427.11.

LastNameFirstNameWeekHrsSalaryBaseAllowancesTotal
ABCD24 $1,423.07$2.55$1,427.11
LastNameFirstNameWeekHrsWageTypeCodeWageTypeDescAmountSalary
ABCD2411M/F Basic Rate1423.071423.07
ABCD242019Laundry Allowance4.042.55
1427.111425.63

Any help will be appreciated

2 Replies

Re: Row Sub Totals PIVOT are incorrect

Can you post a document that demonstrates the problem?


talk is cheap, supply exceeds demand
Not applicable

Re: Row Sub Totals PIVOT are incorrect

Attached is an example - I hope this helps

Community Browser