topic Re: Need HELP ! Rows to Columns ? in QlikView

Need HELP ! Rows to Columns ?

markticoy — Mon, 01 Dec 2014 03:31:51 GMT

Good Day Mates !

I'm sorry if I am using a wrong title for this thread, but I'll explain what my question is all about.

I have a data, source is excel. My problem is that my fields are displayed or arrange in a row. see the picture for reference

Now what I want is, convert this rows to columns. My desired result will be shown below.

Now, is there a way to achieve this kind of result ?

SunilChauhan — Mon, 01 Dec 2014 04:27:52 GMT

change table to pivot to straight

or drag column from horizontal to vertical in pivot table it self

hope this helps

sujeetsingh — Mon, 01 Dec 2014 04:32:46 GMT

Follow this, you need to use Generic load

markticoy — Mon, 01 Dec 2014 08:57:59 GMT

Thank you mates for ideas. I'll be studying your suggestions tonight.

rajeshvaswani77 — Mon, 01 Dec 2014 09:13:03 GMT

Hi,

Change to Pivot table and left click and drag the column to the header till you see a blue arrow pointing.

Un-click here and let it drop. The transpose would have happened.

thanks,

Rajesh Vaswani