Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ts3st1000
Contributor
Contributor

Transpose Table

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

 

MaturitySales product1Sales product2Sales product3
1 year5,9138,133-2,223
2 year39,52538,560929
3 year41,09439,8721,188
4 year97,90479,5164,737
5 year309,085290,6129,810
6 year85,371109,4812,710

That I would like to transpose to look like this:

    

Maturity1 year2 year3 year4 year5 year6 year
Sales product15,91339,52541,09497,904309,08585,371
Sales product28,13338,56039,87279,516290,612109,481
Sales product3-2,2239291,1884,7379,8102,710

Any suggestions to do this please. Thanks very much.

15 Replies
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

Thiago Justen Teixeira Gonçalves
Farol BI
WhatsApp: 24 98152-1675
Skype: justen.thiago
poojashribanger
Creator II
Creator II

i want it to be done in data load editor.

poojashribanger
Creator II
Creator II

i want it to be done in data load editor.

poojashribanger
Creator II
Creator II

i want it to be done in data load editor.

poojashribanger
Creator II
Creator II

i am loading data from qvd

subrato312
Contributor II
Contributor II

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