topic Re: wildcard in QlikView

wildcard

n1ef5ng1 — Mon, 26 Aug 2013 08:51:21 GMT

I have a listbox that contains 200+ fields. I would like to filter on fields that I need.

However, those fields that i would want to filter in listbox have a comma in between.

if(Place = 'Semarang,Java','indonesia;')

becasue of that comma, it does not read that particular field, think is because if statement detect comma as next command.

I tried * such as if(place = 'semarang*','indonesia), it doesn read too.

Any advice

Gysbert_Wassenaar — Mon, 26 Aug 2013 09:01:26 GMT

If you want filter the values in the listbox that contain a comma you can enter *,* as search string.

CELAMBARASAN — Mon, 26 Aug 2013 09:34:40 GMT

I dont think it will do where your using this expression? chart, script...?

if it is a problem then check with this

As gwassenaar said you want to filter the values with comma then go with wildmatch(fieldname, '*,*')

or you need to filter some values(hard coded) then

if(Place = 'Semarang' & Chr(44) & 'Java','indonesia;')

Hope that helps