topic Re: Construct a string to select multiple values by "Select In Field" action in QlikView

Construct a string to select multiple values by "Select In Field" action

vlad_komarov — Tue, 21 Jul 2015 22:01:05 GMT

Hello!

I need to select multiple values in a field using "Select In Field" action. I need to find a way to construct a string for that purpose using a proper values separator.

It works perfectly for single selection: (select the value in ACCOUNT_TYPE field based on the selection in ACCOUNT_TYPE_ABBREV field😞

[Select In Field] --> Field=ACCOUNT_TYPE --> Search String =GetFieldSelections(ACCOUNT_TYPE_ABBREV, '!')

I've tried multiple values separators (the second parameter in GetFieldSelections() function above), but without much success.

I would appreciate any suggestion.

Best regards,

Vladimir

Re: Construct a string to select multiple values by "Select In Field" action

swuehl — Tue, 21 Jul 2015 22:07:36 GMT

The Search String

Re: Construct a string to select multiple values by "Select In Field" action

maxgro — Tue, 21 Jul 2015 22:14:57 GMT

define a variable v

='(' &

concat('"' & ACCOUNT_TYPE_ABBREV & '"', '|')

& ')'

select in field

='$(v)'

Re: Construct a string to select multiple values by "Select In Field" action

vlad_komarov — Tue, 21 Jul 2015 22:24:02 GMT

Swuehl,

I've tried that '(AAA|BBB)' option, does not work directly.

But Massimo's suggestion (below) seems to be working in my case.

Thanks!

Re: Construct a string to select multiple values by "Select In Field" action

vlad_komarov — Tue, 21 Jul 2015 22:25:57 GMT

Massimo,

Thanks, it seems to be working in my case.

The only concern will be a performance issue (using "concat()" ....) since I have to repeat this technique on multiple fields.

But thanks for great suggestion!

Regards,

Vladimir

Re: Construct a string to select multiple values by "Select In Field" action

swuehl — Tue, 21 Jul 2015 22:30:50 GMT

I assume your values contain spaces. If so, you would need to use quotes:

("AA A"|"BB B")

Re: Construct a string to select multiple values by "Select In Field" action

vlad_komarov — Wed, 22 Jul 2015 15:11:28 GMT

Yes, using double quotes helped a bit

I am using composite values separator ["|"], so the final variable looks like:

= '("' & getFieldSelections(ACCOUNT_TYPE_ABBREV, '"|"') & '")'

And it seems to work faster than Concat().

Thanks!