topic Re: Using Concat functions to select values in QlikView

Using Concat functions to select values

Anonymous — Fri, 08 Apr 2016 14:30:55 GMT

Hi,

There's a button with an action in my application which selects values in one field based on what is already selected in the other field.

= if (GetSelectedCount(FieldName1),

'(' & Concat(DISTINCT chr(34) & FieldName1 & chr(34), '|') & ')' )

The problem is that the field 'FieldName1' includes such values as - Publishing house "Name" - where the symbol " is used. Thus, the actions fails to work.

Could you please give a hint how I can solve it?

Thank you in advance,

Larisa

Re: Using Concat functions to select values

sunny_talwar — Fri, 08 Apr 2016 14:33:53 GMT

See if these post helps you out:

Concat Issue

Concat Issue - II

MasterMind: swuehl‌

Re: Using Concat functions to select values

swuehl — Fri, 08 Apr 2016 14:37:00 GMT

A different approach to the ref. threads:

= if (GetSelectedCount(FieldName1),

'(' & Concat(DISTINCT chr(34) & Replace(FieldName1,chr(34),'?') & chr(34), '|') & ')' )

edit: Well, that's not an exact match, so it will find e.g. Publishing house xNames

Re: Using Concat functions to select values

swuehl — Fri, 08 Apr 2016 14:45:57 GMT

And in a more general way, if you want to select field values based on selection in a different field, have a look at the approaches described in detail here:

Copy Selections from one field to another

Re: Using Concat functions to select values

Anonymous — Fri, 08 Apr 2016 15:01:56 GMT

Thank you!