topic Re: Display vertical data in pivot in QlikView

Display vertical data in pivot

Anonymous — Tue, 12 Sep 2017 00:35:42 GMT

in pivot data is possible to be display vertically? Only highlighted one.

I have attached QV file.

Thanks

Re: Display vertical data in pivot

rohitraut — Tue, 12 Sep 2017 06:46:05 GMT

Hello Satish,

Do you want like this?

F1	F2	Tx	TX1	Amber	Green	Red	Unknown
A	1	Amber		1	1	1	1
G	3	Green		1	1	1	1
R	2	Red		1	1	1	1
U	4	Unknown		1	1	1	1

Re: Display vertical data in pivot

Anonymous — Tue, 12 Sep 2017 07:23:41 GMT

Yes It is Possible

Regards

Tahemas Momin

Re: Display vertical data in pivot

Anonymous — Tue, 12 Sep 2017 09:30:30 GMT

I want like this but only circled columns with fully expanded

Thanks

Re: Display vertical data in pivot

Anonymous — Tue, 12 Sep 2017 12:24:57 GMT

Even I'm ok with above scenario but the problem is as soon as I add another Expression

Tx's value displayed horizontally.

How do I keep displaying data vertically even with more than one expressions.

Thanks

Re: Display vertical data in pivot

marcus_sommer — Tue, 12 Sep 2017 13:21:50 GMT

Within the object-properties in tab presentation is an option to display the header vertically but this includes the complete header - all dimensions and all expressions. There are no more options to adjust this but maybe the following workaround is applicable for you: Re: Vertical Data Text in Pivot Table.

- Marcus

Re: Display vertical data in pivot

rohitraut — Tue, 12 Sep 2017 13:47:00 GMT

Hello Satish,

Go to chart properties> presentation>vertical text on column labels.

Disabled the this check box.

Re: Display vertical data in pivot

Anonymous — Tue, 12 Sep 2017 17:16:27 GMT

It works with only one expression, more than one expression it does not work.