Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
larisa_filonova
Creator III
Creator III

Using Concat functions to select values

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

1 Solution

Accepted Solutions
swuehl
MVP
MVP

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

View solution in original post

4 Replies
sunny_talwar

See if these post helps you out:

Concat Issue

Concat Issue - II

MasterMind: swuehl

swuehl
MVP
MVP

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

View solution in original post

swuehl
MVP
MVP

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

larisa_filonova
Creator III
Creator III
Author

Thank you!