topic Re: All Values in one Row in QlikView

All Values in one Row

mr_lampert — Wed, 25 Nov 2020 16:16:04 GMT

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:

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

Re: All Values in one Row

jaumecf23 — Thu, 14 Jun 2018 12:58:41 GMT

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

Re: All Values in one Row

mr_lampert — Thu, 14 Jun 2018 13:01:32 GMT

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

Thank you Jaume!