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

[vlad_komarov]

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

[oknotsen]

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?

[maxgro]

same result in

11.20 SR10 64 bit

[vlad_komarov]

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

[vlad_komarov]

I was using the 11.2 SR10 64-bit release.

[qlikviewwizard]

Hi Vladimi,

Please check these blogs of HIC.

The Expression Search

The Search String

Text searches

Hope this will help you. Thank you.

[vlad_komarov]

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

[jafari_ervin]

This problem happen after publishing your document in qlikview server?

[vlad_komarov]

Yes.

[swuehl]

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

Re: search behaviour negative values