Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Wildcard Match to filter list of products - Calculated Dimension

I found this discussion, but it did not work for me  https://community.qlikview.com/thread/49348

I have a product field called - Product

I want to filter out all the descriptions that have the word "ORGANIC" in the Product field in a calculated dimension for a pivot table

=if(substringcount([Product],"ORGANIC")=0, [Product])

When I do this based on the above link, I get the complete product list not just the Organics.

I also tried

=if(wildmatch(Product,'*ORGANIC*'),Product)

Which results in Null results

I have used

if(match(Field,'Value1','Value2','Value3'),Field)  successfully to narrow down a list box selection before but not using wildcard.and not in a table

1 Solution

Accepted Solutions
sinanozdemir
Specialist III
Specialist III

Hi Cam,

I don't know your dataset, but I used WildMatch and it works:

Capture.PNG

View solution in original post

4 Replies
sinanozdemir
Specialist III
Specialist III

Hi Cam,

I don't know your dataset, but I used WildMatch and it works:

Capture.PNG

Nicole-Smith

Give this a shot:

=if(Product like '*Organic*', Product)

If it doesn't work, please post an example QVW.

maximiliano_vel
Partner - Creator III
Partner - Creator III

=Aggr(Only({<PRODUCT=E({<PRODUCT={"*ORGANIC*"}>} PRODUCT)>} PRODUCT), PRODUCT)

Not applicable
Author

More coffee needed.   I had a lock on another tab for a customer that does not sell Organic products.  Removed lock and my filter worked.

Sorry for all the confusion.  Appreciate all the replies.