topic Re: Combine Multiple Cell Values into One in QlikView

Combine Multiple Cell Values into One

niegel — Fri, 05 Oct 2012 18:58:24 GMT

Hi,

Wondering if it's possible to combine multiple cell values in qlikview as I'll be using the cell values for a script that would need all the selected values concatenated in one line.

Here's an example:

TABLE COMPANY

1 APPLE

1 GOOGLE

1 MICROSOFT

2 MACYS

2 ROSS

2 AMC

3 KFC

3 TACO BELL

3 A&W

I'd like to have a table that would show me:

TABLE COMPANY

1 APPLE, GOOGLE, MICROSOFT

2 MACYS, ROSS, AMC

3 KFC, TACO BELL, A&W

Wondering if it's possible to do.

Re: Combine Multiple Cell Values into One

GabrielAraya — Fri, 05 Oct 2012 19:08:53 GMT

Check this:

Example:

Load * Inline [

TABLE,COMPANY

1,APPLE

1,GOOGLE

1,MICROSOFT

2,MACYS

2,ROSS

2,AMC

3,KFC

3,TACO BELL

3,A&W

];

Final:

Load

TABLE,

concat(COMPANY,';') as COMPANYList

Resident Example

Group By TABLE;

Drop table Example;

Gabriel

Re: Combine Multiple Cell Values into One

niegel — Fri, 05 Oct 2012 19:47:37 GMT

Great, I didn't know that concat() can be used in qlikview.

I can even use it as a Chart Expression for a pivot table! Wonderful!

Thanks!

Re: Combine Multiple Cell Values into One

brooksc57 — Thu, 22 May 2014 21:43:50 GMT

Thank you! So many versions....Join, Merge, Concat...was hard to find...via search.

-------------------------------------------------------------------------

Excel - macro

Access - I forget of the top of my head

SSMS - For XML Path in the T-SQL script side

SSRS - Join( ) on the presentation side

Qlikview - Concat( ) Group By