topic Re: How to transpose rows to columns in QlikView https://community.qlik.com/t5/QlikView/How-to-transpose-rows-to-columns/m-p/886194#M1009822 <HTML><HEAD></HEAD><BODY><P>Also please see a file WhatINeed attached - date in columns and the rest dimensions in rows.</P></BODY></HTML> Wed, 06 May 2015 12:40:56 GMT 2015-05-06T12:40:56Z How to transpose rows to columns https://community.qlik.com/t5/QlikView/How-to-transpose-rows-to-columns/m-p/886191#M1009819 <HTML><HEAD></HEAD><BODY><P><BR />Hi,</P><P>I have the following problem:</P><P>I have a table in qlikview which looks like attached (Date in Rows).</P><P>I want to move Date to columns.</P><P>I tried to mark Horizon in Presentation , but it turns all dimensions to columns.</P><P>Please help.</P></BODY></HTML> Wed, 06 May 2015 10:16:08 GMT https://community.qlik.com/t5/QlikView/How-to-transpose-rows-to-columns/m-p/886191#M1009819 2015-05-06T10:16:08Z Re: How to transpose rows to columns https://community.qlik.com/t5/QlikView/How-to-transpose-rows-to-columns/m-p/886192#M1009820 <HTML><HEAD></HEAD><BODY><P>Create a pivot chart object. Then drag the Date dimension to the right above the expressions. If you see a thick horizontal blue line you can let go and the Date dimension should be pivoted to horizontal layout.</P></BODY></HTML> Wed, 06 May 2015 10:53:53 GMT https://community.qlik.com/t5/QlikView/How-to-transpose-rows-to-columns/m-p/886192#M1009820 Gysbert_Wassenaar 2015-05-06T10:53:53Z Re: How to transpose rows to columns https://community.qlik.com/t5/QlikView/How-to-transpose-rows-to-columns/m-p/886193#M1009821 <HTML><HEAD></HEAD><BODY><P>Hi Gysbert.</P><P>I tried it , but it is not good for me.</P><P>please see a file Pivot&nbsp; : attached.</P><P>Also please see a file WhatINeed attached - date in columns and the rest dimensions in columns.</P><P>Thanks,</P><P></P><P>Inna.</P></BODY></HTML> Wed, 06 May 2015 12:40:22 GMT https://community.qlik.com/t5/QlikView/How-to-transpose-rows-to-columns/m-p/886193#M1009821 2015-05-06T12:40:22Z Re: How to transpose rows to columns https://community.qlik.com/t5/QlikView/How-to-transpose-rows-to-columns/m-p/886194#M1009822 <HTML><HEAD></HEAD><BODY><P>Also please see a file WhatINeed attached - date in columns and the rest dimensions in rows.</P></BODY></HTML> Wed, 06 May 2015 12:40:56 GMT https://community.qlik.com/t5/QlikView/How-to-transpose-rows-to-columns/m-p/886194#M1009822 2015-05-06T12:40:56Z Re: How to transpose rows to columns https://community.qlik.com/t5/QlikView/How-to-transpose-rows-to-columns/m-p/886195#M1009823 <HTML><HEAD></HEAD><BODY><P>Ah, you dragged both dimensions columns. Probably because they weren't expanded yet. Well, simply drag the other one back to the left side of the table.</P></BODY></HTML> Wed, 06 May 2015 12:46:00 GMT https://community.qlik.com/t5/QlikView/How-to-transpose-rows-to-columns/m-p/886195#M1009823 Gysbert_Wassenaar 2015-05-06T12:46:00Z Re: How to transpose rows to columns https://community.qlik.com/t5/QlikView/How-to-transpose-rows-to-columns/m-p/886196#M1009824 <HTML><HEAD></HEAD><BODY><P>Hi, it works!!</P><P>But Total disappeared now.</P><P>How do I add Total to Pivot?</P></BODY></HTML> Wed, 06 May 2015 13:00:51 GMT https://community.qlik.com/t5/QlikView/How-to-transpose-rows-to-columns/m-p/886196#M1009824 2015-05-06T13:00:51Z Re: How to transpose rows to columns https://community.qlik.com/t5/QlikView/How-to-transpose-rows-to-columns/m-p/886197#M1009825 <HTML><HEAD></HEAD><BODY><P>Enable the Partial Sums option for the dimension on the Presentation tab.</P></BODY></HTML> Wed, 06 May 2015 13:02:17 GMT https://community.qlik.com/t5/QlikView/How-to-transpose-rows-to-columns/m-p/886197#M1009825 Gysbert_Wassenaar 2015-05-06T13:02:17Z Re: How to transpose rows to columns https://community.qlik.com/t5/QlikView/How-to-transpose-rows-to-columns/m-p/886198#M1009826 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>it is perfect.</P><P>Thanks a lot!</P></BODY></HTML> Wed, 06 May 2015 13:10:53 GMT https://community.qlik.com/t5/QlikView/How-to-transpose-rows-to-columns/m-p/886198#M1009826 2015-05-06T13:10:53Z