Establish in columns the different measures of a dimension.

[ruben_moya]

Good Morning,

I'm taking my first steps with Qlik Sense and after looking for answers in the forums I have not been able to find an answer.

I just need to associate in different columns the measures that have the same dimension. For example:

From this:

XX1 | 1123

XX1 | 2223

XX2 | 4442

XX3 | 423424

XX3 | 123112

To this:

XX1 | 1123 | 2223

XX2 | 4442

XX3 | 423424 | 123112

Thank you so much in advance,

Best regards.

[sunny_talwar]

Use Concat with Group by to do this...

LOAD Field1,

     Concat(Field2, ' | ') as Field2

From ...

Group By Field1;