How to transpose rows to columns

[#1]

Hi,

I have the following problem:

I have a table in qlikview which looks like attached (Date in Rows).

I want to move Date to columns.

I tried to mark Horizon in Presentation , but it turns all dimensions to columns.

Please help.

[Gysbert_Wassenaar]

Create a pivot chart object. Then drag the Date dimension to the right above the expressions. If you see a thick horizontal blue line you can let go and the Date dimension should be pivoted to horizontal layout.

[#3]

Hi Gysbert.

I tried it , but it is not good for me.

please see a file Pivot  : attached.

Also please see a file WhatINeed attached - date in columns and the rest dimensions in columns.

Thanks,

Inna.

[#4]

Also please see a file WhatINeed attached - date in columns and the rest dimensions in rows.

[Gysbert_Wassenaar · Accepted solution]

Ah, you dragged both dimensions columns. Probably because they weren't expanded yet. Well, simply drag the other one back to the left side of the table.

[#6]

Hi, it works!!

But Total disappeared now.

How do I add Total to Pivot?

[Gysbert_Wassenaar]

Enable the Partial Sums option for the dimension on the Presentation tab.

[#8]

Hi,

it is perfect.

Thanks a lot!