topic Re: Issue in multiple selection in QlikView

Issue in multiple selection

Tue, 12 May 2015 14:14:20 GMT

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

Re: Issue in multiple selection

rubenmarin — Tue, 12 May 2015 14:18:29 GMT

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

sunny_talwar — Tue, 12 May 2015 14:20:37 GMT

Try this may be:

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

Re: Issue in multiple selection

Tue, 12 May 2015 14:28:33 GMT

It didn't work.

Re: Issue in multiple selection

Tue, 12 May 2015 14:31:36 GMT

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

Re: Issue in multiple selection

sunny_talwar — Tue, 12 May 2015 14:33:11 GMT

Will you be able to share a sample application?

Best,

Sunny

Re: Issue in multiple selection

rubenmarin — Tue, 12 May 2015 14:45:46 GMT

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

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

Re: Issue in multiple selection

Tue, 12 May 2015 14:56:05 GMT

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

rubenmarin — Tue, 12 May 2015 15:11:41 GMT

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

Re: Issue in multiple selection

Tue, 12 May 2015 16:09:15 GMT

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

Re: Issue in multiple selection

Tue, 12 May 2015 16:18:10 GMT

Thanks Imad. Thats what I did to resolve the issue.

Re: Issue in multiple selection

Tue, 12 May 2015 16:26:50 GMT

Perfect , credit to you 100%