topic Removing values from List Box in QlikView

Removing values from List Box

helen_pip — Wed, 20 Jul 2016 15:22:10 GMT

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 — Wed, 20 Jul 2016 15:24:06 GMT

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

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

helen_pip — Wed, 20 Jul 2016 15:26:40 GMT

Thanks Sunny T

This is working for me

Thanks

Helen

deec — Wed, 20 Jul 2016 15:30:55 GMT

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