Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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 (3)
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.