Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

poojashribanger
Contributor II

Converting data in Qlik sense

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.

id2015_A2015_M2016_A2016_M2017_A2017_M
101XC
102LX
103X
104CX
Tags (1)
1 Solution

Accepted Solutions
MVP
MVP

Re: Converting data in Qlik sense

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

Screenshot from 2018-04-11 09-41-12.png

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

     year & '_' & rating_type

3 Replies
pascos88
Contributor

Re: Converting data in Qlik sense

Hi,

maybe this could help:

Transpose Table

If not let me know...

MVP
MVP

Re: Converting data in Qlik sense

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:

Screenshot from 2018-04-11 09-33-32.png

MVP
MVP

Re: Converting data in Qlik sense

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

Screenshot from 2018-04-11 09-41-12.png

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

     year & '_' & rating_type

Community Browser