Removing values from List Box

[helen_pip]

Dear Qlikview user

I have 4 values I wish to exclude from a list box so I decided to use the wildmatch function

I.e. =if(WildMatch(Care_Group,'Division*',0),Care_Group)

Howveer the above expression only returns values which start with "Division" and does not put a avlue of 0 against them at all

Is WildMatch the correct function to use to exclude multiple values from a listbox?

Kind Regards

Helen

[sunny_talwar · Accepted solution]

May be this is what you want (placement of parenthesis is not right)

=If(WildMatch(Care_Group,'Division*'), 0, Care_Group)

[helen_pip]

Thanks Sunny T

This is working for me

Thanks

Helen

[deec]

You're close. So if you're trying to hide anything that starts with 'Division*', try:
=if(WildMatch(label,'Division*')=0,label)