Passing Multiple Values

[#1]

I am trying to pass values form one list box into another.  I searched and found some code that I am trying to use:  ='(' & Concat(<field>, '|') & ')'

When I place this code into my dashboard, it crashed QlikView.  I get the error:

Qlikview 9.00 SR5 has stopped working...... then QlikView closes.

Any ideas why this is occuring?

[Jason_Michaelides · Accepted solution]

Are there a large number of records? The thing to remember about Concat() is it doesn't return distinct value lists unless you tell it to. So your result may be huge!  Add in the Distinct qualifier:

='(' &amp; Concat(DISTINCT <field>,'|') &amp; ')'

Hope this helps,

Jason

[Jason_Michaelides]

Did you get this sorted?