topic How to use RangeSum and sort colunm in QlikView https://community.qlik.com/t5/QlikView/How-to-use-RangeSum-and-sort-colunm/m-p/565584#M211048 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>How to use RangeSum and sort colunm?</P><P></P><P>I would like to sort the column "total", but when i use rangesum i can not.</P><P></P><P>Follow example;</P></BODY></HTML> Mon, 10 Feb 2014 17:05:51 GMT 2014-02-10T17:05:51Z How to use RangeSum and sort colunm https://community.qlik.com/t5/QlikView/How-to-use-RangeSum-and-sort-colunm/m-p/565584#M211048 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>How to use RangeSum and sort colunm?</P><P></P><P>I would like to sort the column "total", but when i use rangesum i can not.</P><P></P><P>Follow example;</P></BODY></HTML> Mon, 10 Feb 2014 17:05:51 GMT https://community.qlik.com/t5/QlikView/How-to-use-RangeSum-and-sort-colunm/m-p/565584#M211048 2014-02-10T17:05:51Z Re: How to use RangeSum and sort colunm https://community.qlik.com/t5/QlikView/How-to-use-RangeSum-and-sort-colunm/m-p/565585#M211049 <HTML><HEAD></HEAD><BODY><P>What about sort on dimension day by expression =sum(value).</P><P></P><P>I've attached your example with it sorted.</P></BODY></HTML> Mon, 10 Feb 2014 17:08:55 GMT https://community.qlik.com/t5/QlikView/How-to-use-RangeSum-and-sort-colunm/m-p/565585#M211049 Nicole-Smith 2014-02-10T17:08:55Z Re: How to use RangeSum and sort colunm https://community.qlik.com/t5/QlikView/How-to-use-RangeSum-and-sort-colunm/m-p/565586#M211050 <HTML><HEAD></HEAD><BODY><P>Nicole, its a great solution. But i can not use interactive sort, in my case i have many columns the totals, for example: 1 full, 2 full, avg ... </P><P></P><P>is there another way to do this?</P></BODY></HTML> Mon, 10 Feb 2014 17:22:43 GMT https://community.qlik.com/t5/QlikView/How-to-use-RangeSum-and-sort-colunm/m-p/565586#M211050 2014-02-10T17:22:43Z Re: How to use RangeSum and sort colunm https://community.qlik.com/t5/QlikView/How-to-use-RangeSum-and-sort-colunm/m-p/565587#M211051 <HTML><HEAD></HEAD><BODY><P>If you're allowing the user to sort the chart, it is going to change the values of the rangesum() calculation depending on how the chart is sorted.&nbsp; You may want to look into calculating the rangesum() in the load script instead.</P></BODY></HTML> Mon, 10 Feb 2014 18:16:41 GMT https://community.qlik.com/t5/QlikView/How-to-use-RangeSum-and-sort-colunm/m-p/565587#M211051 Nicole-Smith 2014-02-10T18:16:41Z