Function equivalent to Between

Fri, 29 Jan 2010 11:14:28 GMT

Hello,

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

thanks.

Function equivalent to Between

Fri, 29 Jan 2010 15:43:17 GMT

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.

topic Function equivalent to Between in QlikView

Function equivalent to Between

Function equivalent to Between