How to achieve vertical columns in QlikView pivot / straight table ?

[#1]

Hi All,

I've inserted the image which i prepared in excel due to some concerns. However, i'm having same kind of pivot table in my QlikView Application.

I wanted to know that, is there any possibility to adopt vetical column names (Blue highlighted- 'SubSec'). I tried upto the best of my knowledge but, i'm unable to get this. If anyone came across this, could you please help me on this? will be really appreciated.

Regards,

Zain

Refer to below image for the reference,

[vinieme12]

Go to Presentation tab >> Check the Box >>"Vertical Text on Columns"

[Peter_Cammaert]

Do you mean to say that you want a horizontal dimension with SubSec1 ... SubSecN as labels?

If you have this dimension as a column on the left, expand your pivot table so that it is shown allright, then click the column header and drag it to the right header side. The blue arrow that indicates the position of the vertical column will rotate 90degrees. At that moment, just drop it.

[#4]

No luck! I tried all the possible ways but, not working.

[#5]

No, that isn't working. Only, i can change the position of the dimension by dragging it. I've to change to orientation of the SubSecx to make it appear vertical as we do it in excel.

[Anonymous]

are you sure you're using pivot as chart type?!?

[#7]

yes.
And, even if by checking this option this will only make the column label vertical not the contents.