Function equivalent to Between

[#1]

Hello,

Is there anything equivalent to the in or the between operators in QlikView that we can use in an if statement?

thanks.

[#2]

I think for Between, you're stuck with >= and <=.

For In, you may be able to use Index.

=Index('Test,Yes,Answer,Help', 'Help')
=Index('Test,Yes,Answer,Help', 'Nope')

Index is aimed at finding substrings in strings, but you can use it like an in. Break the values with a character that will never appear in your value list, a comma usually work. If it returns 0, the string was not found. You can use Index()>0 to get a true/false value like an In function would return.