Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

johndoub
New Contributor III

master dimension

i would like to create a master dimension that is a list of customers excluding customers with the last name 'SHOPPER'.

what expression should i use?

thanks.

 

john doub

1 Solution

Accepted Solutions
Partner
Partner

Re: master dimension

In master dimension, try:

if(wildmatch(customer,'*SHOPPER*'),NULL(),customer)

Uncheck include null values after dragging this master dimension into your table.

 

View solution in original post

2 Replies
Partner
Partner

Re: master dimension

In master dimension, try:

if(wildmatch(customer,'*SHOPPER*'),NULL(),customer)

Uncheck include null values after dragging this master dimension into your table.

 

View solution in original post

johndoub
New Contributor III

Re: master dimension

thanks very much.

that worked.