topic Re: WildMatch not working properly in QlikView

WildMatch not working properly

udaya_kumar — Fri, 13 Jul 2012 11:31:01 GMT

Hi,

I am using the below expression in table

=IF(wildMatch(GetFieldSelections(names_list),'*Overlap*') > 0,

'Success',

IF(wildMatch(GetFieldSelections(names_list),'*Trends*') > 0,

'Failure'))

I have a list box with many values and the field in listbox is names_list.

if i select single value in listbox, for example, Trends, then it shows Failure.

if i select multiple value in listbox, for example, Trends and Overlap then it shows success in table expression.

its not showing both success and failure.

but how it is taking overlap always, when i select multiple values?

how to resolve this issue?

please somebody help me.

Fri, 13 Jul 2012 11:53:20 GMT

try this

=IF(wildMatch(GetFieldSelections(names_list),'*Overlap*') > 0,

IF(wildMatch(GetFieldSelections(names_list),'*Trends*') > 0,'Success - Failure','Success'),

IF(wildMatch(GetFieldSelections(names_list),'*Trends*') > 0,'Failure'))

CELAMBARASAN — Fri, 13 Jul 2012 13:10:45 GMT

Try this

Pick(WildMatch(GetFieldSelections(names_list, ',',100),'*Trends*', '*Overlap*', '*Overlap*Trends*'), 'Failure', 'Success', 'Success and Failure')

Celambarasan

swuehl — Fri, 13 Jul 2012 13:14:36 GMT

Or maybe

=pick(

wildMatch(GetFieldSelections(names_list),'*Overlap*Trends*','*Overlap*','*Trends*'),

'Success/Failure',

'Success',

'Failure'

)

edit: Sorry, haven't seen Celambarasan's post before. But I think we should test for the combined selection case first.