Qlik Community

Qlik Community Help Discussions

Discussion board for questions on how to use Qlik Community and its features.

akumar_c
Contributor

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

5 Replies
Not applicable

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

akumar_c
Contributor

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

Thanks Robert..

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

Not applicable

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

akumar_c
Contributor

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

Grade - 3

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

MVP
MVP

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