How can I turn a table from horizontal to vertical

[rittermd]

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.

[patriciousa]

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]

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

[patriciousa]

Yup, my bad.

Thank you.

[petter]

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

[patriciousa]

That's what I thought.

Thank you.

Regards.

[james_butler]

Hi

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

And it will result in:

Regards

James

[michael_klix]

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?