topic Re: Regarding sorting with Expression in Pivot Table in QlikView https://community.qlik.com/t5/QlikView/Regarding-sorting-with-Expression-in-Pivot-Table/m-p/772135#M273986 <HTML><HEAD></HEAD><BODY><P>See attached qvw</P></BODY></HTML> Tue, 27 Jan 2015 11:39:17 GMT Gysbert_Wassenaar 2015-01-27T11:39:17Z Regarding sorting with Expression in Pivot Table https://community.qlik.com/t5/QlikView/Regarding-sorting-with-Expression-in-Pivot-Table/m-p/772134#M273985 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P></P><P>I want to sort the list by expression in pivot table. I have 2 Dimension and 4 Expression(POS,Central,Branch,Total) I want list to be sorted By total.</P><P></P><P>I tried this but not able to achive the same.look at my table bel0w before selection on Approval Related it is appearing in unsorted order as below.</P><P></P><P><IMG alt="Test1.png" class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/76314_Test1.png" style="width: 620px; height: 383px;" /></P><P></P><P>but once i clicked on Approval related then list is coming in sorted order as below</P><P></P><P></P><P></P><P></P><P><IMG alt="Test2.png" class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/76315_Test2.png" style="width: 620px; height: 495px;" /><BR />I dont Want my List to be sorted on selection basis ...I want the sorted list to appear in proper manner whithout selection.</P><P></P><P></P><P>How i can achive the same. my QVW is also attached here for your reference.</P><P></P><P></P><P>Sarfaraz</P></BODY></HTML> Tue, 27 Jan 2015 10:48:52 GMT https://community.qlik.com/t5/QlikView/Regarding-sorting-with-Expression-in-Pivot-Table/m-p/772134#M273985 sarfaraz_sheikh 2015-01-27T10:48:52Z Re: Regarding sorting with Expression in Pivot Table https://community.qlik.com/t5/QlikView/Regarding-sorting-with-Expression-in-Pivot-Table/m-p/772135#M273986 <HTML><HEAD></HEAD><BODY><P>See attached qvw</P></BODY></HTML> Tue, 27 Jan 2015 11:39:17 GMT https://community.qlik.com/t5/QlikView/Regarding-sorting-with-Expression-in-Pivot-Table/m-p/772135#M273986 Gysbert_Wassenaar 2015-01-27T11:39:17Z Re: Regarding sorting with Expression in Pivot Table https://community.qlik.com/t5/QlikView/Regarding-sorting-with-Expression-in-Pivot-Table/m-p/772136#M273987 <HTML><HEAD></HEAD><BODY><P>Dear Gysbert,</P><P></P><P>Thanks a lot for you reply....I got my resolution as expected ...However can u please explain</P><P></P><P>What is dual function ?</P><P>What is fieldIndex function ?</P><P></P><P></P><P>Sarfaraz</P></BODY></HTML> Tue, 27 Jan 2015 11:47:42 GMT https://community.qlik.com/t5/QlikView/Regarding-sorting-with-Expression-in-Pivot-Table/m-p/772136#M273987 sarfaraz_sheikh 2015-01-27T11:47:42Z