topic Re: Can multiple cell values be combined into a single cell? in QlikView

Can multiple cell values be combined into a single cell?

Sun, 13 Jul 2014 17:27:40 GMT

Hi,

I have a requirement as follows:

Col A Col B

123 aaa

234 bbb

123 ccc

456 ddd

123 eee

I need to get the result as below in single cell in separate lines(col B) i.e aaa,ccc and eee which belongs to 123 must be displayed in a single cell one below the other as shown below.

A B

123 1)aaa

2)ccc

3)eee

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

234 1)bbb

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

456 1)ddd

Re: Can multiple cell values be combined into a single cell?

Sun, 13 Jul 2014 17:57:39 GMT

Maybe by using this expression:

Concat(DISTINCT [Col B], chr(10))

I used it in a pivot table with Col A as dimension, and then under the Presentation tab > Wrap Cell Text: 3 lines.

Re: Can multiple cell values be combined into a single cell?

its_anandrjs — Sun, 13 Jul 2014 20:12:14 GMT

You can try simple way also by use of pivot table and add dimensions

Dim1:- [Col A]

Dim2:- [Col B]

And Expression =1

Re: Can multiple cell values be combined into a single cell?

its_anandrjs — Sun, 13 Jul 2014 20:47:51 GMT

From another one you can try see the example for that

Tab1:

LOAD * INLINE [

Col A, Col B

123, aaa

234, bbb

123, ccc

456, ddd

123, eee ];

LOAD

[Col A],

[Col A] as A,

AutoNumber(RowNo(),[Col A])&Chr(41)&[Col B] as B;

LOAD * INLINE [

Col A, Col B

123, aaa

234, bbb

123, ccc

456, ddd

123, eee ];

And on the front end take pivot table and add dimensions A and B

Note:- And Un check the option Suppress Zero-Value from chart Presentation properties.