How to display column values into rows?

[Anonymous]

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

[#2 · Accepted solution]

Hi,

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

Regards,

Amay Patil.

[jagan]

Hi,

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

Hope this helps you.

Regards,

jagan.

[jvitantonio]

Try this:

temp:

LOAD * INLINE [

    Username, Month, Salary

    A, Jan, 1000

    B, Mar, 2000

    C, Dec, 2500

];

a:

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;

[#5]

hi

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

[#6]

hi

use the pivot table

drag and drop field on the top of the table tab

[Anonymous]

Thank you All..

[#8]

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

[Spartan27215]

QlikSense SaaS:  How ?