topic Re: How to Remove default Wild Search ** from the Straight table expression column in QlikView

How to Remove default Wild Search ** from the Straight table expression column

victor5995 — Tue, 24 Mar 2015 20:11:10 GMT

Hi Folks,

I am struggling to remove the by default wild search ** characters from the search window of expression tab in the straight table.

I tried the options of putting User Preferences search settings to "Use Normal Search" and also the option in Document Properties Default search mode to "Use Normal Search". But none of them working specifically to remove wild search characters from search box of expression column of straight table.

If any one can help on this I really appreciated.

Thank You

Re: How to Remove default Wild Search ** from the Straight table expression column

JonnyPoole — Tue, 24 Mar 2015 20:41:34 GMT

hmm.... don't know if there is a way off the top of my head.

Could you get by by adding the expression as a calculated dimension ? You can search the drop down in a dimension and its not wildcard.

Re: How to Remove default Wild Search ** from the Straight table expression column

victor5995 — Tue, 24 Mar 2015 20:54:12 GMT

Hi Jonathan,

Thanks for your quick response but when I am trying to do that i get an error of ""Error in Calculated Dimension"".

I am hopping there should some work around with this.

Thank You

Re: How to Remove default Wild Search ** from the Straight table expression column

Anonymous — Tue, 24 Mar 2015 20:59:55 GMT

Usually the "error in calculated dimension" is easy to fix by adding aggr().

Re: How to Remove default Wild Search ** from the Straight table expression column

victor5995 — Tue, 24 Mar 2015 21:04:29 GMT

Hi Michael,

I think I got that but do you have any other solution for this by keeping the expression as it is and can remove wild search from the search box.

Thank You

Re: How to Remove default Wild Search ** from the Straight table expression column

prieper — Tue, 24 Mar 2015 21:15:23 GMT

You may choose another search-option

Listbox - Properties - General - Advanced Search Options

HTH Peter

Re: How to Remove default Wild Search ** from the Straight table expression column

victor5995 — Tue, 24 Mar 2015 21:22:59 GMT

Hi Peter,

I am dealing with straight table for this issue. and in straight table I do not see any option like that.

For other objects we can change that but I am specifically having issue with straight table expression column search box.

Thank You

Re: How to Remove default Wild Search ** from the Straight table expression column

prieper — Wed, 25 Mar 2015 08:37:30 GMT

Please check

Document Properties -> Presentation -> Default Search Mode

HTH Peter

Re: How to Remove default Wild Search ** from the Straight table expression column

victor5995 — Wed, 25 Mar 2015 13:04:43 GMT

Hi Peter,

This option is not changing it at all. I already mention that in my question.

Thanks

Re: How to Remove default Wild Search ** from the Straight table expression column

prieper — Wed, 25 Mar 2015 13:18:00 GMT

oops - sorry,

was checking on dimension.

Peter

Re: How to Remove default Wild Search ** from the Straight table expression column

Wed, 25 Mar 2015 13:34:19 GMT

Hi..

search mode default properties

search properties <use default > and remove add fields in right side fields .

fist take one copy data after

try once

Regard,

Srinu

Re: How to Remove default Wild Search ** from the Straight table expression column

victor5995 — Wed, 25 Mar 2015 13:37:46 GMT

Hi Sreenu,

Where exactly you want me to check this. Can you please provide the path ?

Thanks

Re: How to Remove default Wild Search ** from the Straight table expression column

Wed, 25 Mar 2015 13:58:38 GMT

i have taken one table and remove the data into straight table

sum({<[Posting Date]=,Item={"A"}>}

but data is showing search that filed data.

try once..

Re: How to Remove default Wild Search ** from the Straight table expression column

victor5995 — Wed, 25 Mar 2015 14:05:33 GMT

Hi Sreenu,

I am not getting what you trying to say. Can you please elaborate more.

Thanks