Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I want to combine two set expression to know how many people in the first expression that also exist in the second expression.
The goal is to know how many people that have attended the ML*-course (kurskod) that also have taken the course SV but with the grade F or -
count({<Klass = {"Avg*"}, KURSKOD = {"ML*"} >} PERSONID )
count({<Klass = {"Avg*"}, KURSKOD = {'SV'}, Betyg -= {'F', '-'} >} PERSONID )
Would this work?
count({<PERSONID = P({<Klass = {"Avg*"}, KURSKOD = {"ML*"} >} PERSONID ), KURSKOD = {'SV'}, Betyg -= {'F', '-'} >} PERSONID )
Try This:
count({<Klass = {'Avg*'}, KURSKOD = {'ML*','SV'}, Betyg = {'F', '-'} >} PERSONID )
Let me know
I will test but it looks like that would give the students with F / - in both ML and SV. In ML the grade dosn't matter
Skickat från min Samsung Mobil
Alessandro Saccone <qcwebmaster@qlikview.com> skrev:
Qlik Community<http://community.qlik.com/>
Indirect set analysis(?)
reply from Alessandro Saccone<http://community.qlik.com/people/Alexandros17?et=watches.email.thread> in New to QlikView - View the full discussion<http://community.qlik.com/message/562077?et=watches.email.thread#562077>
Hi
This is an intersection of the two set expressions:
count({<Klass = {"Avg*"}, KURSKOD = {"ML*"}> * <Klass = {"Avg*"}, KURSKOD = {'SV'}, Betyg = {'F', '-'}>} PERSONID)
This assumes that the '-' for BetygF is not a null. You may need a distinct in front of PERSONID to get the correct count.
HTH
Jonathan
Would this work?
count({<PERSONID = P({<Klass = {"Avg*"}, KURSKOD = {"ML*"} >} PERSONID ), KURSKOD = {'SV'}, Betyg -= {'F', '-'} >} PERSONID )
THanks. That solved it!