Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

rube_moya
New Contributor

Establish in columns the different measures of a dimension.

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.

1 Reply

Re: Establish in columns the different measures of a dimension.

Use Concat with Group by to do this...

LOAD Field1,

     Concat(Field2, ' | ') as Field2

From ...

Group By Field1;

Community Browser