topic Passing Multiple Values in QlikView

Passing Multiple Values

Thu, 22 Sep 2011 19:48:08 GMT

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?

Passing Multiple Values

Jason_Michaelides — Thu, 22 Sep 2011 21:46:42 GMT

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:

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

Hope this helps,

Jason

Passing Multiple Values

Jason_Michaelides — Tue, 27 Sep 2011 22:30:07 GMT

Did you get this sorted?