Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be this is what you want (placement of parenthesis is not right)
=If(WildMatch(Care_Group,'Division*'), 0, Care_Group)
May be this is what you want (placement of parenthesis is not right)
=If(WildMatch(Care_Group,'Division*'), 0, Care_Group)
Thanks Sunny T
This is working for me
Thanks
Helen
You're close. So if you're trying to hide anything that starts with 'Division*', try:
=if(WildMatch(label,'Division*')=0,label)