Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
jleefjcapital
Creator II
Creator II

I would like to transpose the pivot table

I would like to transpose the values in the pivot table switching the row to columns and columns to rows.  Is this possible on the front end of the Qlik Sense?

Thank you,

Jes

4 Replies
harishkumarg
Creator III
Creator III

Are expecting something like this?

Before switching:

Image1.PNG

After switching:

Image2.PNG

To do so swap the Rows and Columns as shown below,

Image3.PNG

Hope this helps!

Regards

Harish

rupamjyotidas
Specialist
Specialist

Unpivot would help you. But what is that you are looking for

Qlik Sense 3.1 - Using Unpivot (video)

hytown2000
Partner - Contributor III
Partner - Contributor III

Yes it is possible, just drag&drop the fields from row to column or vice versa

Before transposing,

Qs1.png

Drag PARAM_TYPE to column,

Qs2.png

Please mark the question as Answered if the reply answers your question to help others.

jleefjcapital
Creator II
Creator II
Author

I found this tutorial to be very helpful, in resolving another issue I was working on.  However, I'm not sure why my data manager is indicating that no data have been loaded to the table even after I've loaded both in the data editor and the data manager screen.

Is there something I'm missing?

Thank you, again!

Jes