topic Re: expression :( in QlikView

expression :(

adiarnon — Thu, 30 Jun 2016 11:48:00 GMT

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

Re: expression :(

migueldelval — Thu, 30 Jun 2016 11:54:27 GMT

Hi Adi,

Could you attach a sample of your data, please.

Regards

Miguel del Valle

Re: expression :(

PrashantSangle — Thu, 30 Jun 2016 12:02:38 GMT

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,

Re: expression :(

adiarnon — Thu, 30 Jun 2016 12:58:13 GMT

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?

Re: expression :(

Anonymous — Thu, 30 Jun 2016 13:20:22 GMT

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

Re: expression :(

Anonymous — Thu, 30 Jun 2016 13:30:45 GMT

Hi Adi,

Can you share some sample data?

Re: expression :(

johnw — Thu, 30 Jun 2016 15:54:58 GMT

Maybe something like this?

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