topic Converting data in Qlik sense in App Development

Converting data in Qlik sense

poojashribanger — Wed, 11 Apr 2018 06:52:12 GMT

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.

pascos88 — Wed, 11 Apr 2018 07:21:50 GMT

Hi,

maybe this could help:

If not let me know...

petter — Wed, 11 Apr 2018 07:39:57 GMT

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:

Then you should end up with this:

petter — Wed, 11 Apr 2018 07:44:53 GMT

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