search object not showing value

[surajap123]

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?

[surajap123]

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.

[Siva_Sankar · Accepted solution]

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.