Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Use Concat with Group by to do this...
LOAD Field1,
Concat(Field2, ' | ') as Field2
From ...
Group By Field1;