topic Filtering data in multibox in QlikView

Filtering data in multibox

Thu, 18 Nov 2010 08:53:07 GMT

Hi,

I have a multibox with column name STATE with the values (US, UK, IN, PK, AUS).

I want to do some filter using wildmatch to get only US and UK.

Can any one explain me how to use wildmatch,

Is the below condition is right??

=WildMatch([STATE],"US","UK")

Thanks,

Thu, 18 Nov 2010 09:02:15 GMT

Hi,

I am using for this a button with a select - trigger and the search string:

= '(' & 'US & '|' & 'UK' & ')'

HtH, Roland

Miguel_Angel_Baeyens — Thu, 18 Nov 2010 09:53:13 GMT

Hello,

If you are not going to use wildcards, Match will work better. So in your multibox add an expression

=If(Match([STATE], 'US', 'UK'), [STATE])

Hope this helps.