5 Replies Latest reply: Feb 2, 2012 10:27 AM by Stefan Wühl

# Count of Employee Grade wise between Median Salary and 44th Salary

Hi Friends,

I am attaching a qvw file. Where I want to calculate the Grade wise count of employee between median salary to 44th Salary.

I am calculating it but it is not coming correct.

For correct out please check out the excel file, where I have done it by manualy for few grade.

Thanks for help

• ###### Count of Employee Grade wise between Median Salary and 44th Salary

Hi Akumar,

I checked for Manager and counted manually 7, the same as your QlikView app.

Are you sure your excel is right?

Regards,

Robert

• ###### Re: Count of Employee Grade wise between Median Salary and 44th Salary

Thanks Robert..

Please Use the Current Attachment...My excel Calculations are correct...

• ###### Count of Employee Grade wise between Median Salary and 44th Salary

I change the expression to this :

=Count(if([Annual Sal_ANSALARY] <= vMedian and [Annual Sal_ANSALARY] >= v44th,Employee_Code,0))

It seems to work (at least for Manager I get 3).

Robert

• ###### Re: Count of Employee Grade wise between Median Salary and 44th Salary

I used the given expression, but my value is not 3. Please check out the attached jpeg.

Employee Count - 49

Median Salry - 96880

44th Salary - 94586

Now i want to count of the employees which is between 96880 and 94586. The correct answer is 3. But I am getting 49, Total no. of employee count.

Regards,

AKumar