Hi, I'm looking for the best way for an end-user to enter a search in a filter-pane to select field values that begin with certain letters, but exclude any that end with a certain letter.
For example, if these were the values in a field:
ab123c; ab12; d1c; ab3d; ab456c; ab789a; b123e; ab456d
and the user wanted the result of a search where the values began with 'ab', but did not end with 'd', they want to enter a search term which would return:
ab123c; ab12; ab456c; ab789a
I would have expected a compound search, such as (^ab* & -?*d) to return those values, but it doesn't. I've read through the documentation, and played around with various options, but cannot get a single search term that returns only the expected values.
So far, the best I have come up with is to type 'ab*d' press enter, then immediately type 'ab' and press enter again. That works, but the process doesn't really make sense in a way that I can explain to an end-user.
Any help would be gratefully received. Please note, this is relating to Qlik Cloud.
