Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Expressions - Qualifying on a variable

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!!!!

0 Replies