Transpose table

[jvelasqu3]

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,

[Lisa_P]

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 ?