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: 
Anonymous
Not applicable

Search functions where field contains Asterisk

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,

5 Replies
Anonymous
Not applicable
Author

My Solution is as below, if anyone has anything better please let me know.

=if(ProductDetail like '*Bulk' or Replace(ProductDetail,'*','%') like '*%*',ProductDetail,'')

Anil_Babu_Samineni

How you want to search? May be Replace it with * to any other functions like !@#$%^&() and then use that condition where you are?

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
devarasu07
Master II
Master II

Hi,

another way you create like this

pick(WILDMATCH(Replace(ProductDetail,'*','%'),'*%*'),ProductDetail,'')

ashwinishinde
Partner - Contributor III
Partner - Contributor III

try this,

if(left(Product,1)='*',Product,

if(WildMatch(Product,'*Bulk'),Product)) as dim,

Anonymous
Not applicable
Author

The * is not necessarily the first character in the field