topic Re: Different rows in one row per customer in QlikView

Different rows in one row per customer

Anonymous — Fri, 13 Jul 2012 06:33:25 GMT

Hi all,

In my database I have the following information:

The problem I am facing is that I get multiple rows for a customer. So, what I would like to see is this:

Is there any way to solve this:

1. In the sript?

2. In a chart?

Kind regards,

Henco

jonathandienst — Fri, 13 Jul 2012 06:41:00 GMT

Henco

In script:

LOAD Customer,

Concat(Branche, ',') As BrancheList

Resident Customers;

In a chart, very similar:

Dimension: Customer

Expression: Concat(DISTINCT Branche, ',')

Regards

Jonathan

Fri, 13 Jul 2012 07:10:37 GMT

Hi,

please find the attached file...!

Regards,

Niranjan M.

Anonymous — Fri, 13 Jul 2012 07:19:35 GMT

Thanks a lot Jonathan!

Cheers,

Henco