Qlik Community

Ask a Question

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Do More with Qlik - for Beginners and Beyond, Topic: Qlik Replicate on January 21, 2PM EST. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

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

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

View solution in original post

3 Replies
Employee
Employee

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

View solution in original post

Contributor II
Contributor II

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!

Creator
Creator

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