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

[Former Member]

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.

[Former Member]

Hi Arun,

Can't you do by creating Condition for top # employees using apprisal rating??

[Former Member]

Hi Pradeep,

not possible to use ranking since Appraisal rating is a characterstics not a key figure value. Any other suggestions..

Thanks

Arun