Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
shahamel
Contributor

using result of a variable in an expression

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