Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I would like to transpose the rows of a table to columns I currently have the following information:
Attribute | Value |
ID | 1 |
Code | 1233 |
Week | 1 |
Sales | 132 |
But I need the information as follows
Id | Code | Week 1 | Week 2 | Week 3 |
1 | 1233 | 132 | 134 | 135 |
The value included in the weeks corresponds to the value of sales
I'd greatly appreciate some insight on how to deal with this in QlikSense.
Many thanks,
Hi,
This issue should be solved with the Generic prefix, but the example you have shown is missing part of the data. We need 3 parts to do this transformation. Entity-Attribute -Value. Do you also have the entity ?