topic formatting and sorting issues in a pivot table....urgent in QlikView https://community.qlik.com/t5/QlikView/formatting-and-sorting-issues-in-a-pivot-table-urgent/m-p/356292#M132224 <HTML><HEAD></HEAD><BODY><P>I agree with Jason.. that L shape thing is basically a box to to display the label for the transposed dimension.</P><P>So there is no way to take it out. But what's wrong in giving a dimension label there? like e.g. "Period" in your case.</P></BODY></HTML> Fri, 18 May 2012 15:11:53 GMT 2012-05-18T15:11:53Z formatting and sorting issues in a pivot table....urgent https://community.qlik.com/t5/QlikView/formatting-and-sorting-issues-in-a-pivot-table-urgent/m-p/356288#M132220 <HTML><HEAD></HEAD><BODY><P><IMG alt="mnthly challenges.JPG" class="jive-image-thumbnail jive-image" onclick="" src="https://community.qlik.com/legacyfs/online/14391_mnthly+challenges.JPG" width="450" /> hi </P><P></P><P>i have created a pivot table in my report and i have used two dimensions in it. the second dimension has been created by concatenating two dimensions </P><P>and i have transposed the second dimension to make CYjan,CY mar etc</P><P>the first issue i am facing is the Black colour L shape figured (circled by red colour).</P><P>and the second issue is of sorting the header for my columns...</P><P>i want to display PYjan,PY feb,PY mar,PY apr,CY jan,CY feb,CY mar,CY apr but how to achieve that??</P></BODY></HTML> Thu, 17 May 2012 09:12:21 GMT https://community.qlik.com/t5/QlikView/formatting-and-sorting-issues-in-a-pivot-table-urgent/m-p/356288#M132220 2012-05-17T09:12:21Z formatting and sorting issues in a pivot table....urgent https://community.qlik.com/t5/QlikView/formatting-and-sorting-issues-in-a-pivot-table-urgent/m-p/356289#M132221 <HTML><HEAD></HEAD><BODY><P> The two issues are related.&nbsp; When you create a dynamic dimension (like you have done here) you need to give it a label in the dimension tab.&nbsp; This label will be in the ringed black box.&nbsp; If you then go to the sort tab you will see your new label - click on it and choose how you want the month dimension sorted. (I guess you have created the dimension by ='CY' &amp; Month, so sort by numeric ascending and you should be good to go.)</P><P></P><P>Hope this helps,</P><P></P><P>Jason</P></BODY></HTML> Thu, 17 May 2012 09:44:17 GMT https://community.qlik.com/t5/QlikView/formatting-and-sorting-issues-in-a-pivot-table-urgent/m-p/356289#M132221 Jason_Michaelides 2012-05-17T09:44:17Z formatting and sorting issues in a pivot table....urgent https://community.qlik.com/t5/QlikView/formatting-and-sorting-issues-in-a-pivot-table-urgent/m-p/356290#M132222 <HTML><HEAD></HEAD><BODY><P> could you plz tell me how to handle that L shape figure which i had circled withred colour?/?</P></BODY></HTML> Fri, 18 May 2012 09:44:59 GMT https://community.qlik.com/t5/QlikView/formatting-and-sorting-issues-in-a-pivot-table-urgent/m-p/356290#M132222 2012-05-18T09:44:59Z formatting and sorting issues in a pivot table....urgent https://community.qlik.com/t5/QlikView/formatting-and-sorting-issues-in-a-pivot-table-urgent/m-p/356291#M132223 <HTML><HEAD></HEAD><BODY><P>Sorry, no.&nbsp; There is another thread open about this same subject.</P></BODY></HTML> Fri, 18 May 2012 10:35:42 GMT https://community.qlik.com/t5/QlikView/formatting-and-sorting-issues-in-a-pivot-table-urgent/m-p/356291#M132223 Jason_Michaelides 2012-05-18T10:35:42Z formatting and sorting issues in a pivot table....urgent https://community.qlik.com/t5/QlikView/formatting-and-sorting-issues-in-a-pivot-table-urgent/m-p/356292#M132224 <HTML><HEAD></HEAD><BODY><P>I agree with Jason.. that L shape thing is basically a box to to display the label for the transposed dimension.</P><P>So there is no way to take it out. But what's wrong in giving a dimension label there? like e.g. "Period" in your case.</P></BODY></HTML> Fri, 18 May 2012 15:11:53 GMT https://community.qlik.com/t5/QlikView/formatting-and-sorting-issues-in-a-pivot-table-urgent/m-p/356292#M132224 2012-05-18T15:11:53Z formatting and sorting issues in a pivot table....urgent https://community.qlik.com/t5/QlikView/formatting-and-sorting-issues-in-a-pivot-table-urgent/m-p/356293#M132225 <HTML><HEAD></HEAD><BODY><P>this is the requirement of the customer for whom i am developing the reports.......plz tell me if there is any way to hide it or remove it???</P></BODY></HTML> Sat, 19 May 2012 12:31:58 GMT https://community.qlik.com/t5/QlikView/formatting-and-sorting-issues-in-a-pivot-table-urgent/m-p/356293#M132225 2012-05-19T12:31:58Z