topic Re: Handling [dash] and [single quote] by search objects in QlikView

Handling [dash] and [single quote] by search objects

vlad_komarov — Wed, 12 Aug 2015 21:45:35 GMT

Hi all,

I've noticed that QV is handling two separate characters [dash --> [-] = chr(45)] and [single quote --> ['] = chr(39)] as identical string character in all search objects.

Example:

I've list of names where these characters are present:

Typing both of these chars in the search object returns the same result: QV selects both of them!

They are clearly the different characters based on the ASCII code:

But for some reason, QV treats them the same way...

Not sure that I have a reasonable explanation for that. Any comments?

The sample app is attached.

I would appreciate any comments and/or suggestions...

Regards,

Vladimir

Re: Handling [dash] and [single quote] by search objects

oknotsen — Wed, 12 Aug 2015 21:59:28 GMT

I think you found an interesting bug (but hope to be proven wrong on that one).

Could you post which version and service release of QlikView you are experiencing this in?

Re: Handling [dash] and [single quote] by search objects

maxgro — Wed, 12 Aug 2015 22:02:21 GMT

same result in

11.20 SR10 64 bit

Re: Handling [dash] and [single quote] by search objects

vlad_komarov — Wed, 12 Aug 2015 23:59:40 GMT

Yes, I forgot to mention, I was using exactly the same version.

Re: Handling [dash] and [single quote] by search objects

vlad_komarov — Thu, 13 Aug 2015 00:00:25 GMT

I was using the 11.2 SR10 64-bit release.

Re: Handling [dash] and [single quote] by search objects

qlikviewwizard — Thu, 13 Aug 2015 01:56:50 GMT

Hi Vladimi,

Please check these blogs of HIC.

The Expression Search

The Search String

Text searches

Hope this will help you. Thank you.

Re: Handling [dash] and [single quote] by search objects

vlad_komarov — Thu, 13 Aug 2015 03:28:10 GMT

Yes, I am usually following Henric's posts, but I didn't find any similarity between my issue and topics reviewed in his articles.

I've posted a question there as well, hopefully it will be discussed.

Thanks!

Vladimir

Re: Handling [dash] and [single quote] by search objects

jafari_ervin — Thu, 13 Aug 2015 05:49:02 GMT

This problem happen after publishing your document in qlikview server?

Re: Handling [dash] and [single quote] by search objects

vlad_komarov — Thu, 13 Aug 2015 07:11:26 GMT

Yes.

Re: Handling [dash] and [single quote] by search objects

swuehl — Thu, 13 Aug 2015 07:18:30 GMT

There seems to be a difference (so also an odd behaviour), when looking at leading minus signs in numbers:

Re: search behaviour negative values

Re: Handling [dash] and [single quote] by search objects

vlad_komarov — Thu, 13 Aug 2015 15:30:30 GMT

Yes, looks like the same problem.

Re: Handling [dash] and [single quote] by search objects

vlad_komarov — Fri, 13 Nov 2015 20:47:32 GMT

It took a while, but I've got a response from Qlik Support:

____________________________________________________________________

According to bug# QLIK-14849 and QLIK- 15675 both describe this behavior is working as design ( not a great design in my opinion), he is what R&D has explain about it:

"When you do global search for E and get a match on a word with É, the search suggestion will change the input line to É. The list of matches may contain words with either E or É.

Just as E and É sorts at the same position in all locales, hyphen and single quote sorts at the same position. Other punctuation sign (e.g. double quote, dot, plus) have higher and different sorting values, and these will not match each other, but hyphen and single quote happens to share search values."

I understand, hyphen and single quotes, are different character and the product should take it as different characters. For that I am going to reach the product manager team to look at this one more time, maybe (no guarantees) that we can make this better or at least documented so for future references and avoid any confusion.

____________________________________________________________________

Regards,

Vladimir