Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
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 🙂