Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Help with a set expression

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.

3 Replies
CELAMBARASAN
Partner - Champion
Partner - Champion

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)

Not applicable
Author

Sorry, did´t work

Not applicable
Author

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

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