Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
dmxmikey
Contributor

how do i get dimension in column rather than row format?

I need to get the cust code next to the customer

Cust code          Customer

2469                    Mr & Mrs

2480                    Donald

Tags (4)
1 Solution

Accepted Solutions

Re: how do i get dimension in column rather than row format?

In a pivot table, just grab each dimension and expression header until the cursor changes into a blue arrow, and drag the arrow to the other side. In this way, you can turn expression into rows, and dimensions into columns.

Option "Allow Pivoting" must be checked in Object Properties->Presentation

Peter

7 Replies

Re: how do i get dimension in column rather than row format?

IN presentation tab of your chart there is a check box "Horizontal" check it and let me know

dmxmikey
Contributor

Re: how do i get dimension in column rather than row format?

Don’t seem to have that option

Delivering the best in Foodservice...

Not applicable

Re: how do i get dimension in column rather than row format?

Hi, this option is present in straight table not in pivot chart.

Re: how do i get dimension in column rather than row format?

In a pivot table, just grab each dimension and expression header until the cursor changes into a blue arrow, and drag the arrow to the other side. In this way, you can turn expression into rows, and dimensions into columns.

Option "Allow Pivoting" must be checked in Object Properties->Presentation

Peter

Partner
Partner

Re: how do i get dimension in column rather than row format?

Agree

Not applicable

Re: how do i get dimension in column rather than row format?

Hi,

Create straight table and you will get this option in presentation tab.

dmxmikey
Contributor

Re: how do i get dimension in column rather than row format?

Thank you all for your help