KPI multiple values

[qliker3]

Hi, 

i have date column, one date can have multiple Products. How do i show the product names in a KPI? Or what could i use instead as an alternative?

Example: when i select a time of day i see the product name, but when i select one more time of day, the kpi value stops working. I want it to show two product names

Thanks 

[Or · Accepted solution]

You could concatenate the results, e.g. Concat(Product,', ').

[qliker3]

this works, is there a way add a new line between the values? 

[Or]

You could try adding chr(13),  but I'm not sure if the KPI object respects newlines.