expression :(

[adiarnon]

hi,

i have 2 table

1. emp_in_courses

2.employees

the key between them is emp_key

* i have a field year - the year of the course

* there are employees that never been in a course

i need to find -

if im filtered on 2016

the employees that not participated in a course in 2016

that means-

(the employees that not participated in a course in 2016  but participated in other years and employees never participated in a course)

how can i write the expression??

i have a filter on year 2016...

adi

[migueldelval]

Hi Adi,

Could you attach a sample of your data, please.

Regards

Miguel del Valle

[PrashantSangle]

Hi,

You want count or what??

try like

count({<Year-={"$(=max(Year))"}>}employee)

It will give selected count employee which are not participated in selected max year.

Regards,

[adiarnon]

my problem is that if im filtered on year=2016 how can i find the employee with no courses

this expression will give me the employees who participated in a course before max(year)  but what about the employees that never participated in a course?

[Anonymous]

Hi,

for employees that never participated in a course

u can try this

count({<emp_in_courses-={"*"}>}employee)

can u attach sample qvw.. it will help to understand the problem

[Anonymous]

Hi Adi,

Can you share some sample data?

[johnw]

Maybe something like this?

count({<year-={'$(=max(year))'},emp_key={"=
count({<year-={'$(=max(year))'}>} course)"
>} distinct emp_key)