topic Re: Search Values in QlikView

Search Values

Fri, 20 Mar 2015 19:42:03 GMT

Hi Community,
I created a Serch button, which will serch the values in "Input Box"
Input box will be fed by users. They usally copy paste the values from an excel file.
The attached .qvw aplication will work fine in development, but when comes to AccessPoint, it is not working.

In Serch button I used below expression

='('&replace(trim(replace(vSearchcustomer,' ',' ') ),' ','|')&')'

Can any one help?

Re: Search Values

Fri, 20 Mar 2015 19:46:55 GMT

Could you please check with both IE plugin & Ajax client?

That makes issue sometimes.

Thanks.

Re: Search Values

Fri, 20 Mar 2015 20:41:27 GMT

In both Cases, it is not working. It is problem with syntax of Search button. because when i try to give the values with once space (eg: 000005 000013 000019 etc), it is working fine in AccessPoint too.

Re: Search Values

prieper — Sat, 21 Mar 2015 09:20:00 GMT

Did you check, which separators are inserted then instead?

Knowing this you may add another REPLACE in your formula

Peter