Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
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
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:
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