topic Re: cross table issue. in QlikView https://community.qlik.com/t5/QlikView/cross-table-issue/m-p/893798#M998357 <HTML><HEAD></HEAD><BODY><P>try tis&nbsp; way,</P><P></P><P>in ur script, left(urfieldname,2) as quarter</P><P></P><P>and use quarter as ur dimension in ur pivot table ,drag the same column on ur pivot table as a header field alsong with ur calculation expressions.</P></BODY></HTML> Wed, 24 Jun 2015 15:26:19 GMT buzzy996 2015-06-24T15:26:19Z cross table issue. https://community.qlik.com/t5/QlikView/cross-table-issue/m-p/893797#M998356 <HTML><HEAD></HEAD><BODY><P style="font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13px;">I have excel file with column QTR which contains all quarters but when i am loading into the qvw, I want that to be in each quarter in different column.</SPAN><A href="https://community.qlik.com/legacyfs/online/90621_excel.PNG"><IMG alt="excel.PNG" class="jive-image image-1" height="215" src="https://community.qlik.com/legacyfs/online/90621_excel.PNG" style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;" width="60" /></A></P><P style="font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">like below image in final qvd file<A _jive_internal="true" href="https://community.qlik.com/servlet/JiveServlet/showImage/2-804593-90439/quarter.PNG" style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #3778c7;"><IMG alt="quarter.PNG" class="jive-image image-2" height="98" src="https://community.qlik.com/legacyfs/online/90622_quarter.PNG" style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;" width="294" /></A></P></BODY></HTML> Wed, 24 Jun 2015 14:40:24 GMT https://community.qlik.com/t5/QlikView/cross-table-issue/m-p/893797#M998356 2015-06-24T14:40:24Z Re: cross table issue. https://community.qlik.com/t5/QlikView/cross-table-issue/m-p/893798#M998357 <HTML><HEAD></HEAD><BODY><P>try tis&nbsp; way,</P><P></P><P>in ur script, left(urfieldname,2) as quarter</P><P></P><P>and use quarter as ur dimension in ur pivot table ,drag the same column on ur pivot table as a header field alsong with ur calculation expressions.</P></BODY></HTML> Wed, 24 Jun 2015 15:26:19 GMT https://community.qlik.com/t5/QlikView/cross-table-issue/m-p/893798#M998357 buzzy996 2015-06-24T15:26:19Z