Skip to Content
0
Former Member
Jul 19, 2005 at 09:29 PM

Need help Designing a Query -with RKFs and CKF or alternate

18 Views

Hi,

Trying to create a query off a HR Headcount IC - to display number of top performing employees (based on appraisal attribute) by region and by function. The format is as follows:

Created 3 RKF's in column structure where

1RKF is KF "Employee Numbers" for characteristics restrictions of date range1, appraisal rating=1,2, employee status =active etc.

2RKF is KF "Employee Numbers" for characteristics restrictions of date range1, appraisal rating=#, employee status =active etc.

3RKF is KF "Employee Numbers" for characteristics restrictions of date range2, appraisal rating=1,2, employee status =active etc.

1CKF is Boolean result of (1RKF OR (2RKF AND 3RKF)

Was able to display correctly all top performing employees in the following format. When "Employee" was selected to row.

-


Top Performer (CKF)

Employee 1----


1

Employee 2----


1

Employee 3----


1

Employee 4----


1

Employee 5----


1

Employee 6----


1

Employee 7----


1

When tried to display the same by Region by Function or even by only Region (Row Char) it doesnÂ’t work. Data is non-sensical.

-


# of Top performers

Region 1 -


FunctionA----


5

Region 1 -


FunctionB----


2

Region 1 -


FunctionC----


3

Region 2 -


FunctionA----


4

Region 2 -


FunctionB----


0

Region 2 -


FunctionC----


7

Region 2 -


FunctionD----


5

Understand that the Boolean CKF is not working correctly. What am I doing wrong ? Please advice fix or alternates.

Thanks.