Expressions - Qualifying on a variable

Wed, 18 Apr 2012 13:20:28 GMT

Hi,

I've created a variable based on an If statement which returns 'Y' if a condition is met and 'N' if the condition is not met,

I'm now trying to qualify on that variable in an expression, but cannot get it to work

E.G.

count ( {$< LevelCode = {UG}, $(vname) = {'Y'} >} PersonID)

The expression performs the count regardless of whether the variable (vname) is Y or N.

I created the variable to get round another problem, where I am trying to only count the PersonID if 2 fields are equal to each other

E,G,

count ( {$ <LevelCode = {'UG'}, LengthStudy = YearStudy >} PersonID)

but that doesn't work either.

The variable is as follows:

=(if(LengthStudy = YearStudy, 'Y', 'N')

Help!!!!

topic Expressions - Qualifying on a variable in QlikView