topic Re: Using 'Select in field' action for multiple selections in QlikView

Using 'Select in field' action for multiple selections

varunreddy — Thu, 01 Oct 2015 21:32:09 GMT

Hi Guys,

I am stuck using 'Select in field' action for multiple selections. This is what I am trying

Field - [Primary Issue Driver]

Search String -

(BCBS|BCBS - Accuracy)

Can any one help with this syntax?

Thanks in advance

Regards,

Varun

swuehl — Thu, 01 Oct 2015 21:33:30 GMT

Try a search string with double quotes when the search string contains blanks:

("BCBS"|"BCBS - Accuracy")

varunreddy — Thu, 01 Oct 2015 21:36:32 GMT

Hi Swuehl,

This is not working.

Thanks for your time though!

Regards,

Varun

swuehl — Thu, 01 Oct 2015 21:43:04 GMT

Seems to work for me though.

varunreddy — Thu, 01 Oct 2015 21:50:32 GMT

Tried copying the same expression you gave me, but not working.

swuehl — Thu, 01 Oct 2015 21:58:49 GMT

Have you had a look to the attached sample above to check for differences?

If you can't open it, could you post your sample app (just the field loaded into data model)?

prabhu0505 — Thu, 01 Oct 2015 22:04:35 GMT

I guess there could be some data quality issue.

Use trim function for the field on edit script to remove unwanted spaces if any.

varunreddy — Fri, 02 Oct 2015 13:50:24 GMT

Hi Swuehl,

The expression is working today.

Thanks for your response!

Cheers!

jafari_ervin — Mon, 11 Jan 2016 14:03:07 GMT

Thanks for your helpful answer