Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
algirdas_luk
Contributor
Contributor

Filter pane search with quotation marks in the data

Hello,

I've come accross a weird problem in Qlik Sense:

The search in a filter pane doesn't seem to work properly if there are quotation marks in the data that is being searched. 

I've attached 3 screens as an example: we have a list of customers, if we search for lifosa, everything's OK, but if we search for bauen, there are no matches. Is there any workaround for this or do I need to remove quotation marks from the data entirely?

p.s. I understand that typing in *bauen* would give me the result needed, but that is an additional inconvenience for the user... 

algirdas_luk_0-1644923571024.pngalgirdas_luk_1-1644923609598.png

algirdas_luk_2-1644923626675.png

 

 

2 Replies
chris_djih
Creator III
Creator III

the most obvious workaround would be to remove the quotation marks in your data script:
purgechar(Customer,'"') as Customer

If you found help, mark the correct answer and give some likes to ALL contributors, that tried to help.
algirdas_luk
Contributor
Contributor
Author

Well yes, of course. But I was wondering why does the search behave that way with quotation marks and is there any way to change the way it behaves without changing the data itself 🙂