topic Re: Multiple selection using button. in QlikView

Multiple selection using button.

Wed, 25 Apr 2012 10:16:17 GMT

I have to select multiple values in a field using button.
I am using this logic:

Field: Product, and
Search String: '(A|B|C)'

It is working fine but one of my product has name (Product Name) i.e. there is a space in between the names and here the logic fails

'(A|B|C|Product Name)' is not selecting Product Name. What could be the possible logic?

Re: Multiple selection using button.

Wed, 25 Apr 2012 10:25:28 GMT

Hi:

Try the following '(A|B|C|Product*Name)'

Thanks,
Narasimha K

Multiple selection using button.

Wed, 25 Apr 2012 10:34:48 GMT

Thanks Narasimha.

It works but i have another problem. I have the field called Product list where all the products are listed and some of them have space in between. I can not pass the names manually. It has to be dynamic. So is there a way so that the space in between gets converted to *.

Multiple selection using button.

Anonymous — Wed, 25 Apr 2012 10:48:01 GMT

hope this will help you,

Use this string function to change the Space into *

=replace([YourField],' ','*')

Regards

Ashok

Multiple selection using button.

Wed, 25 Apr 2012 11:54:33 GMT

Thanks Ashok