Aggregate fields for specific value in one field

[Anonymous]

Hi all,

In my QlikView document I load customers and addresses. Sometimes customers do have more then one address.

The usual data display would be:

Customer	Address
CUSTOMER1	ADRESS1
CUSTOMER1	ADRESS2

I would like to display the data as following:

Header 1	Header 2
CUSTOMER1	ADRESS1, ADRESS2

Any thoughts on this?

Kind regards,

Henco

[swuehl · Accepted solution]

Try a

=concat(Address, ', ')

e.g. in a table chart.

Regards,

Stefan

[Anonymous]

Thanks a lot Stefan!