topic Selecting multiple values using concat function in QlikView

Selecting multiple values using concat function

seahyanzheng — Mon, 15 Oct 2018 04:15:52 GMT

Hi,

May i ask how do i select multiple values on field event trigger?

For example, on "_metricNo" selections, i like "_metrics" to be selected.

Im able to get "_metrics" values:

='(' & concat(''& _metrics & '','|') & ')' which returns these values

and i put in get field selection for "_metrics" but it doesnt get selected. The values above are delimited by '|'.

May i ask how do i proceed?

Thanks!

ashwinisondkar — Mon, 15 Oct 2018 04:44:24 GMT

Could you please try below expression

='('&Concat(_Metrics,'|')&')'

seahyanzheng — Mon, 15 Oct 2018 05:03:44 GMT

Manage to get the answer:

='(' & Concat(DISTINCT chr(34) & _metrics & chr(34), '|') & ')' instead of

='(' & concat(''& _metrics & '','|') & ')'

Thanks.