Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

How do I convert Columns into Rows?

This is my input :

ID    Jan 20      Feb 20

1      1000          2000

2      2000          2000


I am looking to convert this into something like this below:

ID    Month                   Value

1     01/01/2020          1000

1     02/01/2020           2000

2     01/01/2020           2000

2      02/01/2020          2000


How do I need to script it in Qlik Sense?

Labels (3)
1 Solution

Accepted Solutions

2 Replies


Here is shows some examples too -> Working with crosstables in the data load script