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: 
Jsobrinho77
Creator
Creator

wildcard in Qliksense filter/column

Hi guys,

How can I search without using a wildcard ( *,~ or others )? for example, if I search y, 0,3,p,s I can't see the result, because is not the first letter. Only the first letter return search, is it possible to return a search with any letter independent of the first or not?

Jsobrinho77_0-1650989984892.png

 

Labels (4)
1 Reply
vinieme12
Champion III
Champion III

You need to use wildcards for searching parts withing a string 

Or

 You can use advanced search using string functions like substringcount() , index() ,findoneof() or even wildmatch()

=Substringcount (ID,'y')

Or

=Index(ID,'y')

Or

=Wildmatch (ID,'*y*','*0*')

You can refer to help section for more on these functions

https://help.qlik.com/en-US/sense/February2022/Subsystems/Hub/Content/Sense_Hub/Scripting/StringFunc...

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.