topic Re: How to display column values into rows? in QlikView

How to display column values into rows?

Anonymous — Fri, 19 Apr 2013 10:31:21 GMT

Hi,

I have a table like,

Username	Month	Salary
A	Jan	1000
B	Mar	2000
C	Dec	2500

i want the resultant table like,

Username	Jan	Mar	Dec
A	1000	-	-
B	-	2000	-
C	-	-	2500

Re: How to display column values into rows?

Fri, 19 Apr 2013 10:35:03 GMT

Hi,

You can use pivot table in chart to change a row into column.

Regards,

Amay Patil.

Re: How to display column values into rows?

jagan — Fri, 19 Apr 2013 10:37:47 GMT

Hi,

Use pivot table and drag and drop the Month dimension to the top of the header.

Hope this helps you.

Regards,

jagan.

Re: How to display column values into rows?

jvitantonio — Fri, 19 Apr 2013 10:45:59 GMT

Try this:

temp:

LOAD * INLINE [

Username, Month, Salary

A, Jan, 1000

B, Mar, 2000

C, Dec, 2500

];

left join

load Username,Salary as [Jan]

Resident temp

where Month = 'Jan';

left join

load Username,Salary as [Mar]

Resident temp

where Month = 'Mar';

left join

load Username,Salary as [Dec]

Resident temp

where Month = 'Dec';

drop Fields Month, Salary;

Re: How to display column values into rows?

Fri, 19 Apr 2013 11:03:23 GMT

cursor keep on month then drag it, then you see like this image

now then this drag cursor drop on then salary column like this image

then output like this

Re: How to display column values into rows?

Fri, 19 Apr 2013 11:15:23 GMT

use the pivot table

drag and drop field on the top of the table tab

Re: How to display column values into rows?

Anonymous — Fri, 19 Apr 2013 11:52:44 GMT

Thank you All..

Re: How to display column values into rows?

Fri, 19 Apr 2013 11:56:18 GMT

Check this thread http://community.qlik.com/thread/79615

Re: How to display column values into rows?

Spartan27215 — Tue, 18 Oct 2022 21:35:54 GMT

QlikSense SaaS: How ?