using result of a variable in an expression

shahamel — Wed, 24 Jul 2013 07:52:44 GMT

Dear users,

I would like to see if a person passed his examen (geslaagd = 1) when he leaves (uitstroom = 1) school.

This is what i think i should do, the point is that this doesn't not work.

This formule should count all 'deelnemersnrs' who got their diploma at least once.

count(

where geslaagd = 1

if a person studies 4 year and gets a diploma (geslaagd = 1) during it's second year ,but does not

pass his examen (geslaagd = 0) during it's fourht year it still count's as 1, because during it's time in

school he has passed his examen at least once

where uitstroom = 1

Deelnemernr

This formule should count all 'deelnemernrs' who didn't got their diploma.

count(

where geslaagd = 0

if a person studies 4 year and did not get his diploma during that period

where uitstroom = 1

Deelnemernr

Please help,

Gr. Sandeep

topic using result of a variable in an expression in QlikView