Discussion Board for collaboration related to QlikView App Development.
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,
A different approach to the ref. threads:
'(' & 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
View solution in original post
See if these post helps you out:
Concat Issue - II
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