topic Re: Sorting in Pivot for 2 dimension in QlikView https://community.qlik.com/t5/QlikView/Sorting-in-Pivot-for-2-dimension/m-p/728727#M1061830 <HTML><HEAD></HEAD><BODY><P>Hi Vikas,</P><P></P><P>Pls go to Chart properties -&gt; Sort Tab -&gt; Check Expression from Sort By (For Dimension Division)</P><P>-&gt; use <STRONG>Sum<SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Annual Target]</SPAN><SPAN style="font-size: 8pt;">)&nbsp; </SPAN></STRONG><SPAN style="font-size: 8pt;">Code and select Descending -&gt;Apply</SPAN></P><P>Thanks</P></BODY></HTML> Thu, 18 Sep 2014 08:22:43 GMT 2014-09-18T08:22:43Z Sorting in Pivot for 2 dimension https://community.qlik.com/t5/QlikView/Sorting-in-Pivot-for-2-dimension/m-p/728726#M1061829 <HTML><HEAD></HEAD><BODY><P>Dear all </P><P></P><P>I have attached format report&nbsp; which is in pivot table I Want to show Highest Division target wise ( I.e. Warren Should come first) and </P><P>then sorting on&nbsp; annual target .</P><P></P><P>It is urgent please share your experience.</P><P></P><P>Vikas</P></BODY></HTML> Thu, 18 Sep 2014 08:11:30 GMT https://community.qlik.com/t5/QlikView/Sorting-in-Pivot-for-2-dimension/m-p/728726#M1061829 vikasmahajan 2014-09-18T08:11:30Z Re: Sorting in Pivot for 2 dimension https://community.qlik.com/t5/QlikView/Sorting-in-Pivot-for-2-dimension/m-p/728727#M1061830 <HTML><HEAD></HEAD><BODY><P>Hi Vikas,</P><P></P><P>Pls go to Chart properties -&gt; Sort Tab -&gt; Check Expression from Sort By (For Dimension Division)</P><P>-&gt; use <STRONG>Sum<SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Annual Target]</SPAN><SPAN style="font-size: 8pt;">)&nbsp; </SPAN></STRONG><SPAN style="font-size: 8pt;">Code and select Descending -&gt;Apply</SPAN></P><P>Thanks</P></BODY></HTML> Thu, 18 Sep 2014 08:22:43 GMT https://community.qlik.com/t5/QlikView/Sorting-in-Pivot-for-2-dimension/m-p/728727#M1061830 2014-09-18T08:22:43Z Re: Sorting in Pivot for 2 dimension https://community.qlik.com/t5/QlikView/Sorting-in-Pivot-for-2-dimension/m-p/728728#M1061831 <HTML><HEAD></HEAD><BODY><P>Kunal thanks for reply&nbsp; actually I have done this but not able to get desire sorting.</P><P></P><P>Vikas</P></BODY></HTML> Thu, 18 Sep 2014 09:28:58 GMT https://community.qlik.com/t5/QlikView/Sorting-in-Pivot-for-2-dimension/m-p/728728#M1061831 vikasmahajan 2014-09-18T09:28:58Z Re: Sorting in Pivot for 2 dimension https://community.qlik.com/t5/QlikView/Sorting-in-Pivot-for-2-dimension/m-p/728729#M1061832 <HTML><HEAD></HEAD><BODY><P><IMG alt="$1B7F2B548FB03095.bmp" class="jive-image" src="https://community.qlik.com/legacyfs/online/67089_$1B7F2B548FB03095.bmp" /><BR />Vikas, I am geeting this type of sorting applying the same sorting chriteria.</P><P>Is that what you are looking for?</P></BODY></HTML> Thu, 18 Sep 2014 11:06:33 GMT https://community.qlik.com/t5/QlikView/Sorting-in-Pivot-for-2-dimension/m-p/728729#M1061832 2014-09-18T11:06:33Z Re: Sorting in Pivot for 2 dimension https://community.qlik.com/t5/QlikView/Sorting-in-Pivot-for-2-dimension/m-p/728730#M1061833 <HTML><HEAD></HEAD><BODY><P>I have also getting same thing in excel when i try in test environment but live scanario is giving me wrong result let me check whether there is problem in source data !</P><P>Vikas</P></BODY></HTML> Thu, 18 Sep 2014 11:20:04 GMT https://community.qlik.com/t5/QlikView/Sorting-in-Pivot-for-2-dimension/m-p/728730#M1061833 vikasmahajan 2014-09-18T11:20:04Z