topic Something similar to in() function? in QlikView

Something similar to in() function?

Fri, 27 May 2011 13:56:50 GMT

Hello,

Is there any function that I can use to check whether the contents of a variable is in a given list?

Example: If Fruit In("apple","orange","kiwi") then ...

Thanks.

Something similar to in() function?

jolivares — Fri, 27 May 2011 14:01:40 GMT

Try Match() function.

If(Match(Fruit,'apple','orange',kiwi')>0,true,false)...

Something similar to in() function?

stephencredmond — Fri, 27 May 2011 16:15:37 GMT

Just FYI, if you are using a function like Match (or MixMatch or WildMatch) which returns a number representing the position in the list that the item is found, you can get away with the ">0" in the condition. The function returns 0 if the item is not found in the list which QlikView interprets as "False". Anything else, other than 0, is "True" (doesn't have to be just -1).

Might save you a second or two 😉

Stephen