topic Re: Cross tab in QlikView https://community.qlik.com/t5/QlikView/Cross-tab/m-p/775844#M1045244 <HTML><HEAD></HEAD><BODY><P>you could use pivot table and drag column(<STRONG>Month</STRONG>) from verticle to horizontal</P><P></P><P></P><P>or</P><P></P><P>Crosstable(Month,Data,3)</P><P>Load Company,</P><P>Product,</P><P>*</P><P>from path</P><P></P><P>and then calculate expressions</P></BODY></HTML> Wed, 19 Nov 2014 09:14:27 GMT SunilChauhan 2014-11-19T09:14:27Z Cross tab https://community.qlik.com/t5/QlikView/Cross-tab/m-p/775842#M1045242 <HTML><HEAD></HEAD><BODY><P>anyone have idea how to convert my expression in to row and dimension into columns like this </P><P></P><P></P><P><IMG alt="Capture.JPG.jpg" class="jive-image" src="https://community.qlik.com/legacyfs/online/71628_Capture.JPG.jpg" style="width: 620px; height: 158px;" /></P></BODY></HTML> Wed, 19 Nov 2014 09:00:38 GMT https://community.qlik.com/t5/QlikView/Cross-tab/m-p/775842#M1045242 2014-11-19T09:00:38Z Re: Cross tab https://community.qlik.com/t5/QlikView/Cross-tab/m-p/775843#M1045243 <HTML><HEAD></HEAD><BODY><P>first load data as is</P><P>T1:</P><P>load * from ....</P><P>then</P><P></P><P>crosstable(Month,MonthName,4) load * resident your table</P></BODY></HTML> Wed, 19 Nov 2014 09:13:38 GMT https://community.qlik.com/t5/QlikView/Cross-tab/m-p/775843#M1045243 ali_hijazi 2014-11-19T09:13:38Z Re: Cross tab https://community.qlik.com/t5/QlikView/Cross-tab/m-p/775844#M1045244 <HTML><HEAD></HEAD><BODY><P>you could use pivot table and drag column(<STRONG>Month</STRONG>) from verticle to horizontal</P><P></P><P></P><P>or</P><P></P><P>Crosstable(Month,Data,3)</P><P>Load Company,</P><P>Product,</P><P>*</P><P>from path</P><P></P><P>and then calculate expressions</P></BODY></HTML> Wed, 19 Nov 2014 09:14:27 GMT https://community.qlik.com/t5/QlikView/Cross-tab/m-p/775844#M1045244 SunilChauhan 2014-11-19T09:14:27Z Re: Cross tab https://community.qlik.com/t5/QlikView/Cross-tab/m-p/775845#M1045245 <HTML><HEAD></HEAD><BODY><P>The options suggested above&nbsp; for script level and are correct.</P><P>Whereas you can try Pivot table in UI and make the dimension&nbsp; as columns </P></BODY></HTML> Wed, 19 Nov 2014 09:19:51 GMT https://community.qlik.com/t5/QlikView/Cross-tab/m-p/775845#M1045245 sujeetsingh 2014-11-19T09:19:51Z