Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
poojashribanger
Creator II
Creator 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
1 Solution

Accepted Solutions
petter
Partner - Champion III
Partner - Champion III

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

View solution in original post

3 Replies
pascos88
Creator II
Creator II

Hi,

maybe this could help:

Transpose Table

If not let me know...

petter
Partner - Champion III
Partner - Champion III

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

petter
Partner - Champion III
Partner - Champion III

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