Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Talk to Experts, a LIVE Q&A Webinar. Bring your Qlik Sense Business questions on Aug. 4th. Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Partner
Partner

Qlik Sense concatenating multiple rows into one cell

We have data in rows, like this:

A, 1

A, 2

A, 3

B, 1

B, 6

 

For  a CRM-related project, we want to concatenate all of the "A" and "B" data together, in a cell, that would look like this:

A, 1 2 3

B, 1 6

In other words, we would combine the second column of data in a single table cell for each distinct value of the first column.  

Is this achievable using a load script with Qlik Sense Enterprise?

Labels (2)
1 Reply
Highlighted
Partner
Partner

Re: Qlik Sense concatenating multiple rows into one cell

Try this approach.

 

LOAD

LetterField as Letter,

Concat(distinct NumberField, ' ') as Numbers

FROM Data

GROUP BY  LetterField;

 

Plees ekskuse my Swenglish and or Norweglish spelling misstakes