Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
rittermd
Master
Master

How can I turn a table from horizontal to vertical

I have data by month.

I want to see the months across the top (columns) and the rest of the data in rows.  By default I am getting the opposite and I don't see how to change that in Qlik Sense.

26 Replies
patriciousa
Creator II
Creator II

Hi Petter.

Is it possible to rotate the the table in the table expression instead in the LOAD script?

Thank you in advance.

Regards.

petter
Partner - Champion III
Partner - Champion III

You mean "instead of in the LOAD script?"  ?

patriciousa
Creator II
Creator II

Yup, my bad.

Thank you.

petter
Partner - Champion III
Partner - Champion III

For Qlik Sense you will have to use the functionality of the Pivot Table to do that.

patriciousa
Creator II
Creator II

That's what I thought.

Thank you.

Regards.

james_butler
Contributor III
Contributor III

Hi

This can be done in Sense via a pivot table set out like this:

And it will result in:

Regards

James

michael_klix
Creator II
Creator II

Please let me add my problem to this thread:

I need the same "vertical Pivot" but to display something special. Raw data is ax XLS with metadata about projects. The idea is to select one project and get a vertical list of it's properties.

 

Example raw data in xls:

Project     owner    started          status            description

A                 Peter       1.1.2010      open                lorem ipsum.....(can be long)

B                 Paul          2.2.2012      closed

C                 Mary          3.3.2013     closed

 

Desired output when project A is chosen:

Project:    A

Owner:     Peter

Status:       open

Description: lorem ipsum...... (cell should be dynamic in size)

 

Maybe I am just cought in my old QlikView style where a pivot table would do the job. Any ideas?