topic simple if contains statement in QlikView

simple if contains statement

Thu, 07 Oct 2010 15:10:28 GMT

I know this must be a simple one to solve but I cant figue it out. I'm trying to break up some data based upon an ID field. If the ID begins with v then its a product else its an order. Currently running the below everything is displaying as an order, im guessing this be because its using the * as a character instead of a wildcard.

Can someone please point me in the right direction?


if("ID"='v*', 'products', 'orders') as datatype

Thanks

simple if contains statement

Miguel_Angel_Baeyens — Thu, 07 Oct 2010 15:20:20 GMT

Hello,

Use the following:

=IF(WILDMATCH(ID, 'V*'), 'products', 'orders')

Hope that helps

simple if contains statement

Thu, 07 Oct 2010 15:30:07 GMT

Many thanks, works perfectly!

Re: simple if contains statement

nickmarlborough — Tue, 29 Oct 2024 17:16:08 GMT

How would i do this with multiple instances?

For example:

If i have x3 different categories - 'Fruit' , 'Vegetable' , 'Meat' and i want to create a new column that when the Category contains 'Fruit' it is the combination of Field: TYPE and Field: COLOUR but when Category contains 'Vegetable' it is the combination of Field: TYPE and Field: SIZE but when it contains 'Meat' it is the Field: #of pieces (this is an integer) and anything else in CATEGORY is Null.

Hope this is explained well,