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?

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!

Highlighted
Not applicable

Re: Pivot table dimensions to show on rows and columns

Thanks.. that was very helpful.