We've had some staff at a customer finding it non-intuitive how Qlik Sense search works. Some people expect it to be a Google-like experience which is more based around whole-word and multiple matches - which is pretty much what Qlik does - but others expect it to be more like Excel which will locate the search term anywhere in a string - these users are left puzzled.
Sharing the very useful Qlik Sense Cheat Sheet version 2.0 - Qlik Community - 1667455 can only get so far as it's not easy for users to find / consume at the right time.
Of course Qlik aren't going to change the fundamental way search works but we wondered if some enhancement to the search experience might help... let's call it "Search Assistance". By default, things would work as they do now, but as part of the interface (perhaps under the three-dots button) there would be an option to enable different search options like full text and fuzzy. This could then simply change the search term for the user.
e.g.
- search for roo and you'll see "rooster" (i.e. those values with roo at the start of a word)
- click the full text option and it will change your search term to *roo* and return "kangaroo", "brood" and "rooster" etc. (i.e. those values with roo anywhere in the string)
- click the fuzzy text option and it will change your search term to ~roo and return the above plus "bro", "road" etc
Qlik Partner Ambassador 2024