Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Pivot table dimensions to show on rows and columns

Hi everyone,

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

Pivot 1.PNG

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

Pivot 2.PNG

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

Tags (1)
1 Solution

Accepted Solutions

Re: Pivot table dimensions to show on rows and columns

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

4 Replies

Re: Pivot table dimensions to show on rows and columns

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

Highlighted
Not applicable

Re: Pivot table dimensions to show on rows and columns

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

Pivot3.PNG

Re: Pivot table dimensions to show on rows and columns

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!

Not applicable

Re: Pivot table dimensions to show on rows and columns

Thanks.. that was very helpful.