topic Re: Multiply values in one row in QlikView

Different values in one row

Tue, 01 Dec 2015 13:11:25 GMT

Hi!

I have many clientIDs linked to every sales manager.

I created the simple table below:

I would like to create this table, and put all the clientIDs in the same row, for every sales manager:

thanks ,

Naama

sunny_talwar — Tue, 01 Dec 2015 18:03:30 GMT

Try this:

Table:

LOAD [sales manager],

Only(email) as email,

Concat(clientID, ', ') as clientID

From Source

Group By [sales manager];

sunny_talwar — Tue, 01 Dec 2015 18:05:24 GMT

For your sample:

Table:

LOAD [sales manager],

Only(email) as email,

Concat(clientID, ',') as clientID

Group By [sales manager];

LOAD [sales manager],

email,

clientID

FROM

[https://community.qlik.com/thread/193637]

(html, codepage is 1252, embedded labels, table is @1);

anlonghi2 — Tue, 01 Dec 2015 19:29:38 GMT

Hello Naamamor,

use Sales manager and email as dimensions of a straight table and define the expression as concat(clientID,',')

Look at attached qvw

Best regards

Andrea