Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
mr_lampert
New Contributor III

All Values in one Row

Hello Community,

simple question: in this small table are different values:

Load * Inline [

Number, Word

1, Delta

2, Bravo

1, Echo

2, Charlie

];

This is the table on the left in this screenshot:

Skizze.png

How can I create a table (no pivot table), that looks like my masterful artwork on the right? It should show all possible values of another value in one row.

Thanks and greetings from Germany

David

Tags (3)
1 Solution

Accepted Solutions
jaumecf23
Contributor III

Re: All Values in one Row

Use this in your expression -> Concat(Word,',')

2 Replies
jaumecf23
Contributor III

Re: All Values in one Row

Use this in your expression -> Concat(Word,',')

mr_lampert
New Contributor III

Re: All Values in one Row

Concat? Perfect! Why can not things always be this easy?

Thank you Jaume!