Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

niegel
New Contributor

Combine Multiple Cell Values into One

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.

1 Solution

Accepted Solutions
Employee
Employee

Re: Combine Multiple Cell Values into One

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;

BR

Gabriel

3 Replies
Employee
Employee

Re: Combine Multiple Cell Values into One

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;

BR

Gabriel

niegel
New Contributor

Re: Combine Multiple Cell Values into One

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!

brooksc57
New Contributor III

Re: Combine Multiple Cell Values into One

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

Community Browser