Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
jleefjcapital
Contributor 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
Contributor III

Re: I would like to transpose the pivot table

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
Valued Contributor

Re: I would like to transpose the pivot table

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

Qlik Sense 3.1 - Using Unpivot (video)

hytown2000
New Contributor III

Re: I would like to transpose the pivot table

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
Contributor II

Re: I would like to transpose the pivot table

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