topic Re: Vertical measures in QlikView

Vertical measures

simonagheo — Wed, 25 Nov 2020 16:16:04 GMT

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!

Re: Vertical measures

marcus_sommer — Tue, 12 Jul 2016 10:34:22 GMT

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

Re: Vertical measures

sunny_talwar — Tue, 12 Jul 2016 10:34:30 GMT

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.

Re: Vertical measures

simonagheo — Mon, 18 Jul 2016 09:29:22 GMT

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?

Re: Vertical measures

marcus_sommer — Mon, 18 Jul 2016 10:14:44 GMT

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

Re: Vertical measures

simonagheo — Mon, 18 Jul 2016 11:31:39 GMT

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

Re: Vertical measures

marcus_sommer — Mon, 18 Jul 2016 12:43:34 GMT

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

Re: Vertical measures

simonagheo — Mon, 18 Jul 2016 13:38:16 GMT

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

Re: Vertical measures

marcus_sommer — Mon, 18 Jul 2016 20:09:10 GMT

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