Transpose Table

[ts3st1000]

Hi, I am displaying a table looking like the following:

Maturity	Sales product1	Sales product2	Sales product3
1 year	5,913	8,133	-2,223
2 year	39,525	38,560	929
3 year	41,094	39,872	1,188
4 year	97,904	79,516	4,737
5 year	309,085	290,612	9,810
6 year	85,371	109,481	2,710

That I would like to transpose to look like this:

Maturity	1 year	2 year	3 year	4 year	5 year	6 year
Sales product1	5,913	39,525	41,094	97,904	309,085	85,371
Sales product2	8,133	38,560	39,872	79,516	290,612	109,481
Sales product3	-2,223	929	1,188	4,737	9,810	2,710

Any suggestions to do this please. Thanks very much.

[Thiago_Justen_]

Hi folks,

Don't forget: transpose is not recommended in Qlik Sense.

Documentation: https://help.qlik.com/en-US/sense/November2017/Subsystems/Hub/Content/Scripting/functions-statements...

Cheers

[poojashribanger]

i want it to be done in data load editor.

[poojashribanger]

i want it to be done in data load editor.

[poojashribanger]

i want it to be done in data load editor.

[poojashribanger]

i am loading data from qvd

[subrato312]

How to draw different line chart for each product  showing sales trend over the years, something like sparkline?

Data table being same as the first table shown above

Thanks

subrato