Customize Dimensions with Wildcards

[lneidorf]

Hi there.

I support a product that has a Business Intelligence module powered by Qlik Sense. 

In constructing some Bar Charts, I've been trying to customize some of the underlying fields, to no avail.

We have a filed called "User Name".  This pulls from both internal administrative users, and external client users. I'm trying to use the User Name as a Dimension, and restrict it to only users with a certain prefix. That way, these charts would display only the client user data, eliminating the need to apply filters every time.

I'm trying to write something that would restrict the resulting data to only users with user names starting with an "abc" prefix. Something like this:

[User Name] = abc*

The syntax doesn’t appear to be working. Any advice?

Thanks very much!

[ArnadoSandoval]

Hi @lneidorf 

This expression returns 1 if the the user name start with 'abc', zero otherwise

WildMatch(Mid([User Name],1, 3), 'abc*')

 Hope this helps,

[lneidorf]

Thanks for the response, @ArnadoSandoval. I stumbled upon this expression, which seemed to do the trick:

=If([User Name] like 'abc*', [User Name])

[ArnadoSandoval]

@lneidorf 

Actually it does the job !!!