Hi,

I was wondering if there is a faster shorter way to write a case statement with multiple criteria. For example:

case(

field_1 = "apple"

or

field_1 = "pear"

or

field_1 = "apple"

or

field_1 = "peach";

"fruit")

basically I wan to know if I can type field_1 = all the values for that result in it without having to type field_1 = for each value that will result if fruit. Like:

case(

field_1 = "apple", "peach", "pear";

"fruit")

I am just a lazy typer I guess, but can something like this be done?

Thanks in advance

Try:

Case (

not IsEmpty ( FilterValues ( field ; "apple¶peach¶pear" ) ) ;

"fruit"

)

Awesome,

works like a charm, Thanks Comment!