topic Re: Marge / concatenate the field data in QlikView

Marge / concatenate the field data

daniel_f — Mon, 22 Apr 2013 12:44:14 GMT

Hi All,

How can I Marge / concatenate the data from a field horizontally like below example:

Now I have the data like that: (tablebox)

And I want to transform the data like that (tablebox):

Which is the right function to flat the data?

Thanks in advance,

Dany

Gysbert_Wassenaar — Mon, 22 Apr 2013 17:30:46 GMT

The concat function: concat(Invoice,' ; ') if used in a chart with Order as dimension.

Or in the script:

load Order, concat(Invoice,' ; ') as invoices

from ...mysource...

group by Order;

daniel_f — Tue, 23 Apr 2013 06:40:55 GMT

Thank you Gysbert, it was exactly what i needed !