topic Re: PICK ( WILDMATCH ( Dimension Question in QlikView

PICK ( WILDMATCH ( Dimension Question

Tue, 29 Jan 2013 19:45:29 GMT

Hello QV Community,

I am making a pivot table that will show total email vs total mail. I have a field labeled FName which has the location name and type of communication so I need to search the whole text for just 'mail' or 'email', and I need to just show email and mail. When I use the below expression, the figures are correct and it shows the label Email, but not the label Mail (it shows a dash ' - ' ). How can I adjust this to show both Email and Mail?

PICK(WILDMATCH(TRIM(UPPER(FName)), '*EMAIL*') ,'Email','Mail')

Re: PICK ( WILDMATCH ( Dimension Question

Gysbert_Wassenaar — Tue, 29 Jan 2013 19:51:09 GMT

If wildmatch doesn't match anything it will return 0. And you specified only one match pattern. Pick starts at 1, so feeding pick a 0 won't give a result. So try this:

PICK(WILDMATCH(TRIM(UPPER(FName)), '*EMAIL*')+1 ,'Mail','Email')

Re: PICK ( WILDMATCH ( Dimension Question

Tue, 29 Jan 2013 19:54:29 GMT

Perfect, thank you for the correction and explanation.