topic Re: Indirect set analysis(?) in QlikView

Indirect set analysis(?)

Fri, 04 Jul 2014 09:52:41 GMT

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 )

Re: Indirect set analysis(?)

alexandros17 — Fri, 04 Jul 2014 10:11:05 GMT

Try This:

count({<Klass = {'Avg*'}, KURSKOD = {'ML*','SV'}, Betyg = {'F', '-'} >} PERSONID )

Let me know

Re: Indirect set analysis(?)

Fri, 04 Jul 2014 10:34:04 GMT

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>

Re: Indirect set analysis(?)

jonathandienst — Fri, 04 Jul 2014 10:59:43 GMT

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

Re: Indirect set analysis(?)

jerrysvensson — Fri, 04 Jul 2014 11:01:36 GMT

Would this work?

count({<PERSONID = P({<Klass = {"Avg*"}, KURSKOD = {"ML*"} >} PERSONID ), KURSKOD = {'SV'}, Betyg -= {'F', '-'} >} PERSONID )

Re: Indirect set analysis(?)

Fri, 04 Jul 2014 11:04:53 GMT

THanks. That solved it!