topic Re: search object not showing value in QlikView

search object not showing value

surajap123 — Thu, 17 Jul 2014 09:08:09 GMT

Hi All,

In the search object, i have put a field containing values (Eg- ^XYZ).

Whenever i search XYZ in the search object, it gives no result.

Whenever i search *^XYZ* in the search object, it gives no result.

whenever i search *^* in the search object, it gives no result.

Only when i search *XYZ* in the search object, it gives the result.

My requirement is to make the search object find me ^XYZ, whenever i search with XYZ or ^. How can i archieve this?

Re: search object not showing value

surajap123 — Fri, 18 Jul 2014 08:56:30 GMT

Any input of this one please...

Is there anyway to search special characters like ^ in a search object. I have values are like ^XYZ, but when i search with just ^ , the search object shows nothing.

Re: search object not showing value

Siva_Sankar — Fri, 18 Jul 2014 09:35:59 GMT

Suraj,

With respect to qlikview search, there are some special characters we're using to search.

Example: * to search zero or more characters

? to search any single character

^ to search whole string.

So when you type ^, qlikview interpreting that you are forcing to search a whole string.

You try replacing ^ with a dollar symbol or & symbol or # symbol, the search will be accomplished.