topic Re: Like % expression? in QlikView

Like % expression?

Anonymous — Wed, 15 Feb 2017 17:44:22 GMT

Hi,

I am trying to create an expression in a multibox, the idea is that if the user start with US, MX, CAN, BRA, HON, GUA, exc. should be America, if it's JAP, CHN, etc should be APJ. I am using something like:

=If (AuthenticatedUser like 'US%','AMERICA',
If (AuthenticatedUser like 'EM%','EMEA',
If (AuthenticatedUser like 'AP%','AP','Without Region')))

But this is not working, all records are now on Without Region.

What can I do to have them grouped correctly?

Re: Like % expression?

sunny_talwar — Wed, 15 Feb 2017 17:57:05 GMT

I would suggest you to create a new field in the script with and then use that as your multibox field

If(AuthenticatedUser like 'US%','AMERICA',
If(AuthenticatedUser like 'EM%','EMEA',
If(AuthenticatedUser like 'AP%','AP','Without Region'))) as NewField

Re: Like % expression?

vinieme12 — Wed, 15 Feb 2017 18:04:27 GMT

Have you tried Match () or wildmatch () with pick ()?

Look here how to use pick () with MATCH ()

The match() Function | Qlikview Cookbook

Re: Like % expression?

sunny_talwar — Wed, 15 Feb 2017 18:06:41 GMT

Also, try using * instead of %

=If(AuthenticatedUser like 'US*','AMERICA',
If(AuthenticatedUser like 'EM*','EMEA',
If(AuthenticatedUser like 'AP*','AP','Without Region')))

Re: Like % expression?

Anonymous — Wed, 15 Feb 2017 18:10:45 GMT

Thank you I changed '%' to '*' and everything is working now.