Converting data in Qlik sense

[poojashribanger]

Hi,

I have data like this

id       year     rating_type     rating

101    2015        A                   X

101    2015        M                  C

102    2016        A                   X

102    2015        A                   L

103    2017        A                   X

104    2016        A                   X

104    2015        M                  C

  i want data like this in qlik sense

how can i achieve this.

please help.

id	2015_A	2015_M	2016_A	2016_M	2017_A	2017_M
101	X	C
102	L		X
103					X
104		C	X

[pascos88]

Hi,

maybe this could help:

Transpose Table

If not let me know...

[petter]

You can load the data in as you have in your top table and then you simply create a Pivot Table in a sheet in your application:

1. Add id as the first dimension
2. Select Add Data / Row and add year
3. Select Add Data / Row and add rating_type
4. Select Add Data / Measure and add the expression =Concat(rating,',')

Then you should end up with this:

[petter · Accepted solution]

You could also join the two dimensions year and rating_type so you get something closer to what you asked for:

Then you don't add year and rating_type as separate dimensions but make a calculated dimension with the expression:

     year & '_' & rating_type