Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
sibrulotte
Creator III
Creator III

Check if value is possible

Hi,

conditional calculations: I'd like to check if the value 'Bunny' is possible in the field [Animals], what would the formula look like?

Everytime I try to use P in my formulas I get an error (and I've checked the tutorials many times...)

1 Solution

Accepted Solutions
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Or...

max(match(Animals, 'Bunny'))>0


-Rob

View solution in original post

4 Replies
Not applicable

TRy to use wildmatch and concat functions.

ex.

wildmatch(concat(Animals,';'),'Bunny')

hope this helps

Mc

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Or...

max(match(Animals, 'Bunny'))>0


-Rob

Clever_Anjos
Employee
Employee

or...

index(concat(Animals), 'Bunny'))>0

er_mohit
Master II
Master II

in calcualtion condition write

Fieldname='Bunny'

or

wildmatch(Fieldname,'Bunny')