topic Help with a set expression in QlikView

Help with a set expression

Fri, 17 Oct 2014 12:08:05 GMT

I need help to combine this expression in a way that work. The aim is to get students with a F or '-' in Course EN but the should also have E or better in BOTH Ma and Fy.

This is what I have

Count({< PersonID = P({<Course= {'EN'}, Grade = {'F','-'} >} PersonID), Course= {'MA','FY'}, Grade = {'A','B','C','D','E'} >} Distinct PersonID

My problem is that the expression also gives me students with E or better in either of MA or FY. I only want those with E or better in both. I have tested with diffrent combinations of >*< on the Coursefield with no luck.

Re: Help with a set expression

CELAMBARASAN — Fri, 17 Oct 2014 12:11:52 GMT

Try this

Count({< PersonID = P({<Course= {'EN'}, Grade = {'F','-'} >} PersonID), Course= {'MA'}, Grade = {'A','B','C','D','E'} >*< PersonID = P({<Course= {'EN'}, Grade = {'F','-'} >} PersonID), Course= {'FY'}, Grade = {'A','B','C','D','E'} >} Distinct PersonID)

Re: Help with a set expression

Fri, 17 Oct 2014 12:36:09 GMT

Sorry, did´t work

Re: Help with a set expression

Fri, 17 Oct 2014 12:48:28 GMT

Attach a sample data if that could be to any help.

edit, sorry. wrong file, now the right are attached