Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
Hi,
You can use pivot table in chart to change a row into column.
Regards,
Amay Patil.
Hi,
You can use pivot table in chart to change a row into column.
Regards,
Amay Patil.
Hi,
Use pivot table and drag and drop the Month dimension to the top of the header.
Hope this helps you.
Regards,
jagan.
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;
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
hi
use the pivot table
drag and drop field on the top of the table tab
Thank you All..
Check this thread http://community.qlik.com/thread/79615
QlikSense SaaS: How ?