topic How to sort by Total in Pivot in QlikView https://community.qlik.com/t5/QlikView/How-to-sort-by-Total-in-Pivot/m-p/210323#M64949 <HTML><HEAD></HEAD><BODY><P>Hi Holke,<BR /><BR />When you select the sort value in the properties of the chart, you will need to use the expression option. Try using the TOTAL qualifier in the expression sort....<BR /><BR />=Sum(Total Omzet)</P><P>Cheers.<BR /><BR />Ad.</P></BODY></HTML> Thu, 08 Oct 2009 21:19:47 GMT Anonymous 2009-10-08T21:19:47Z How to sort by Total in Pivot https://community.qlik.com/t5/QlikView/How-to-sort-by-Total-in-Pivot/m-p/210322#M64948 <HTML><HEAD></HEAD><BODY><P>How can I sort the data in a Pivot table by the "total Omzet" column in the pivot below ?</P><P>Thanx in advance</P><P>Holke</P><P><IMG alt="error loading image" class="jive-image error-loading-image" src="https://community.qlik.com/legacyfs/online/-495_sourceID:495" /></P></BODY></HTML> Thu, 08 Oct 2009 05:11:09 GMT https://community.qlik.com/t5/QlikView/How-to-sort-by-Total-in-Pivot/m-p/210322#M64948 2009-10-08T05:11:09Z How to sort by Total in Pivot https://community.qlik.com/t5/QlikView/How-to-sort-by-Total-in-Pivot/m-p/210323#M64949 <HTML><HEAD></HEAD><BODY><P>Hi Holke,<BR /><BR />When you select the sort value in the properties of the chart, you will need to use the expression option. Try using the TOTAL qualifier in the expression sort....<BR /><BR />=Sum(Total Omzet)</P><P>Cheers.<BR /><BR />Ad.</P></BODY></HTML> Thu, 08 Oct 2009 21:19:47 GMT https://community.qlik.com/t5/QlikView/How-to-sort-by-Total-in-Pivot/m-p/210323#M64949 Anonymous 2009-10-08T21:19:47Z How to sort by Total in Pivot https://community.qlik.com/t5/QlikView/How-to-sort-by-Total-in-Pivot/m-p/210324#M64950 <HTML><HEAD></HEAD><BODY><P>If you set the sort on the field labeled "K" with the expression Sum(Omzet) before any of the sorting for the field labeled "B", it should sort by total.</P></BODY></HTML> Thu, 08 Oct 2009 22:07:53 GMT https://community.qlik.com/t5/QlikView/How-to-sort-by-Total-in-Pivot/m-p/210324#M64950 2009-10-08T22:07:53Z