Checking like condition in expression

Anonymous — Wed, 09 Feb 2011 14:13:14 GMT

Hi,

How to check the like condition in expression?

e.g. I have 1 column in which data is like ABC;DEF considering ABC and DEF are 2 different employees.

I have listbox with the employees. Now when user selects ABC from the list box what I am looking for is data only ABC as well as data ABC;DEF should be picked up.

Kind of looking something similar to "like" in SQl. I have tried wildmatch but it doesnt work if we give column name. String has to give in the command.

Thanks.!

--Swapnil

Checking like condition in expression

Wed, 09 Feb 2011 22:06:28 GMT

Hi,

Try something like the following,

Sum({$<FIELDTOSEARCH={'*$(=Only(FIELDWITHSELECTEDVALUE))*'}>}Sales)

I hope this helps.

Thanks

Nick

topic Checking like condition in expression in QlikView

Checking like condition in expression

Checking like condition in expression