Showing multiple values in one field

[Dayna]

Hello All,

I have a straight table that shows information for a sales order, but the item may belong to more than one site.. Within QV, if the row has more than one value it produces a null ( - ) value in the cell. I would like to concatenate the values and show both.. How would I do this?

Any help you could provide would be appreciated!!

Many thanks,
Dayna

[Miguel_Angel_Baeyens · Accepted solution]

Hello Dayna,

You can use the Concat() aggregation function so

Concat(DISTINCT FieldWithMultipleValues, ',')

Hope that helps

[Dayna]

Perfect!! Thank you!!