Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Cam,
I don't know your dataset, but I used WildMatch and it works:
Give this a shot:
=if(Product like '*Organic*', Product)
If it doesn't work, please post an example QVW.
=Aggr(Only({<PRODUCT=E({<PRODUCT={"*ORGANIC*"}>} PRODUCT)>} PRODUCT), PRODUCT)
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.