Vertical measures

[simonagheo]

Hello,

Is there a simple way to display vertically the measures in pivot table?

Instead of:

Qty	Selling Price1	Selling Price2	Total Price	Avg	…
jan	10	15	2	20	2
feb	10	20	2	20	2

I want:

jan	feb	…
Qty	10	10
Selling Price1	15	20
Selling Price2	2	2
Total Price	20	20
Avg	2	2
…

Thank you!

[marcus_sommer]

You could drag the expressions like the dimensions within a pivot - within the expression-label press the left mouse-key and drag the expressions where you want.

- Marcus

[sunny_talwar]

Is this QlikView or Qlik Sense?

If it is QlikView then drag the expression label row to the left side so that it becomes a column and drag the month column to the top so that it becomes a row.

[simonagheo]

Thank you! It worked, but now I have another problem. I have a long text for measure label  but the expresion result is not so big. 

I want to resize only the amount, but I want to be able to see the entire label for the expresion.

How can I do that?

[marcus_sommer]

If you hover with the mouse over the edge from the columns you should get a small arrow-cross which you could click and by holding them you could size the columns smaller or wider.

- Marcus

[simonagheo]

It doesn't work in my case. I tried this, but when I resize the columns, it resizes the labels and vice versa.

[marcus_sommer]

It looked if you had applied the option of an unique column-width - therefore try it again. By a pivot-chart have only all columns of each single expression the same column-width - different expressions and the dimensions could have different column-widths:

- Marcus

[simonagheo]

If I display expresions horizontal it works for me too, but when I drag them vertically it doesn't work.

[marcus_sommer · Accepted solution]

Ok. now I understand what you meant. But there is no possibility to adjust the column-width in the way you want. You need to live with them (and maybe find a shorter expression-label) or as a workaround you enabled multiple rows and used a line-break within the expression-label.

- Marcus