Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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...
the most obvious workaround would be to remove the quotation marks in your data script:
purgechar(Customer,'"') as Customer
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 🙂