Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
My field in question has been marked with an asterisk to indicate that it is not in use anymore. This becomes problematic when using Search functions in qlikview. Is there a way around this issue?
Field Example:
*Product1 102020
Product2 10102 Bulk
Product 3 10101
What I need is to identify all fields that do not contain the word "Bulk" and do not contain an Asterisk.
I was trying to use the below formula but the asterisk provides an issue. Can anyone make any recommendations?
if(Product like '*Bulk','',Product) as a calculated dimension.
Regards,
My Solution is as below, if anyone has anything better please let me know.
=if(ProductDetail like '*Bulk' or Replace(ProductDetail,'*','%') like '*%*',ProductDetail,'')
How you want to search? May be Replace it with * to any other functions like !@#$%^&() and then use that condition where you are?
Hi,
another way you create like this
pick(WILDMATCH(Replace(ProductDetail,'*','%'),'*%*'),ProductDetail,'')
try this,
if(left(Product,1)='*',Product,
if(WildMatch(Product,'*Bulk'),Product)) as dim,
The * is not necessarily the first character in the field