'If statement for multiple values'

[alaaj907]

Hello,

I'm trying to write a Qlik sense code that checks if there are multiple values in a cell and puts 'yes' or 'no.

more than 3 values= 'yes'

3 values or less= 'no'

This is what I came up with so far:

if(match(Field,'1','2','3','4'),'y',if(match(Field,'1','2','3'),'n',''))

[Or]

I'm not clear on what you're trying to do - "cell" is not a concept that Qlik typically uses.

Generally, if you want a count of the values, you use Count(Field) or Count(Distinct Field).

[rwunderlich]

if (Count(DISTINCT Field) > 3, 'yes'. ,no')

-Rob