Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Issue in multiple selection

Hi,

I have selected action as "select in field"

Field =[Transaction ID]

Search String ='('&replace(vSearch,',','|')&')'

But when I'm giving multiple transaction id's separted by comma and hitting on test. It doesn't work.

Can someone please help me with the error in my button.

Please find the attached screen shot.

Thanks in advance.

Regards,
Adi

11 Replies

Re: Issue in multiple selection

Hi Aditya, can you try this?:

Search String ='('&replace('$(vSearch)',',','|')&')'

You can test the expression first in a text box to check the string it returns.

Re: Issue in multiple selection

Try this may be:

='(' & Replace(PurgeChar(vSearch, ' '), ',' , '|') & ')'

Not applicable

Re: Issue in multiple selection

It didn't work.

Not applicable

Re: Issue in multiple selection

It didn't work Ruben. But its returning the exact string that I pasted in the text box.

Re: Issue in multiple selection

Will you be able to share a sample application?

Best,

Sunny

Re: Issue in multiple selection

I checked one example where I did something similar, I have each value between double quotes, it should be:

Search String ='("'&replace('$(vSearch)',',','"|"')&'")'

Not applicable

Re: Issue in multiple selection

Hi Ruben,

My search string is correct.

I just removed = before [Transaction ID]. And it's working fine now.

Anyways I appreciate your help.

Thank you.

Re: Issue in multiple selection

Ok, I didn't thought that '=' was part of the Field Name.

Not applicable

Re: Issue in multiple selection

What Aditya meant is to to remove the equal sign before the transaction_id field. see screen shot. it should work.

button.png