Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Ipsita20191
Contributor III
Contributor III

Convert data from columns to rows in Qlik sense

Hi All,

Can you please help me on this issue I am facing.

Input Table:

Pkey Startweek EndWeek Value
1 202203 202205 22
1 202208 202210 11
1 202215 202217 10
2 202203 202205 33

 

I want data set as like this:

Pkey Week Value
1 202203 22
1 202204 22
1 202205 22
1 202208 11
1 202209 11
1 202210 11
1 202215 10
1 202216 10
1 202217 10
2 202203 33
2 202204 33
2 202205 33
Labels (4)
2 Replies
Ipsita20191
Contributor III
Contributor III
Author

Can you guys help me on this , As it is bit urgent.. I know I have posted few times back. Your help is much appreciated.

Ipsita20191
Contributor III
Contributor III
Author

I have Calendar Table where I have Retail week as column where we have all retail week. Can we use this column to get Final table.