topic Re: switch row to column in QlikView

switch row to column

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

hi,

is there anyway to switch row to columns on presentation layer straight table or pivot table? I know i can do that through the script and generic load but the issue is that the source comes from two tables..

Let me know your thoughts

Best,

Alec

Re: switch row to column

sunny_talwar — Wed, 20 Apr 2016 22:00:47 GMT

There is an option to use 'Horizontal' for straight table on the presentation tab and for pivot table you just need to drag and drop to move dimensions and expressions around

Re: switch row to column

alec1982 — Wed, 20 Apr 2016 22:10:41 GMT

Hi Sunny,

Thank you for the information. I was aware of this solution but for some reason it no longer works for me..

Can you please send me a sample

Here is my table sample:

Sample:

Load * Inline

Customer_Type, STN_Type, Revenue

Broker,SAD,1000

Retail, QWV,200

Broker ,ARD, 1200

Broker, IUY, 890

Retail, ABC,230

];

I need the Customer_Type to show vertically, and the STN_Type to show horizontally

Thanks for all the help.

Re: switch row to column

swuehl — Wed, 20 Apr 2016 22:35:01 GMT

Like this in a pivot table?

Customer_Type	STN_Type	ABC	ARD	IUY	QWV	SAD
Broker		-	1200	890	-	1000
Retail		230	-	-	200	-

Re: switch row to column

sunny_talwar — Thu, 21 Apr 2016 00:05:16 GMT

alec1982 wrote:

I was aware of this solution but for some reason it no longer works for me..

Do you know what changed which caused it to not work any more? You upgraded to a different version of QV? or something else?

Re: switch row to column

Mihir_Mehta — Tue, 16 Jun 2020 03:44:13 GMT

Can you please explain how you did that.I have exceeded my maximum document recoveries limit so I can't open your qvw file.