Pivot table dimensions to show on rows and columns

[#1]

Hi everyone,

I have a pivot table chart with 2 dimensions (Status and Vendor Type) and it appears like this:

But is there a way to show the Vendor type values on the row:

I used the simple table chart but it shows the 2 dimensions as 2 columns which is not what I want.

[sunny_talwar · Accepted solution]

Have you tried dragging the VendorType dimension to the left to make it as row instead of column?

[#3]

Yes that worked. Thanks Sunny!

Is there a way to hide the dimension names from the view. I renamed the labels to spaces for the 2 dimensions but the borders around empty cells look odd

[sunny_talwar]

Easy option is to put a text box object over those two cells. Alternatively you can play around with Customer Format Cell.

Custom Format Cell dialog ‒ QlikView

Custom formatting table cells - The Qlik Fix! The Qlik Fix!

[#5]

Thanks.. that was very helpful.