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: 
Vince_CH
Creator III
Creator III

Define field types by certain content contained

Dear Friends,

I have one field containing unregular contents like below. I want to define the field type differently if it contains certain contents inside, e.g. if including "bearing", then to define the type as Bearing. 

In excel search, it is possible to search ambiguously, i am not sure if in Qlik sense there is such function similarly? 

thanks in advance!

11.jpg

1 Solution

Accepted Solutions
vishsaggi
Champion III
Champion III

DId you try like below change the else condition value as your require.

=IF(Wildmatch(Description, '*bearing*')>0, 'Bearing', Description)

View solution in original post

2 Replies
vishsaggi
Champion III
Champion III

DId you try like below change the else condition value as your require.

=IF(Wildmatch(Description, '*bearing*')>0, 'Bearing', Description)
Vince_CH
Creator III
Creator III
Author

thanks, it works great!