topic Re: Problem of sorting values in a pivot table (to get an accumulation of ratio) in QlikView https://community.qlik.com/t5/QlikView/Problem-of-sorting-values-in-a-pivot-table-to-get-an/m-p/429149#M559456 <HTML><HEAD></HEAD><BODY><P>Load the same set of data group by dimension columns with sum and sort by sum</P></BODY></HTML> Tue, 18 Jun 2013 08:49:14 GMT skchen97 2013-06-18T08:49:14Z Problem of sorting values in a pivot table (to get an accumulation of ratio) https://community.qlik.com/t5/QlikView/Problem-of-sorting-values-in-a-pivot-table-to-get-an/m-p/429145#M559452 <HTML><HEAD></HEAD><BODY><P>Dear all,</P><P></P><P>I need your expertise to realize a cumulated/cumulative ratio in a Pivot Table.</P><P></P><P>Indeed you can see in my example that I meet some difficulties :</P><P></P><P>- the sorting (column Rank) doesn't work like I want. My values must be sorted by decreasing Turnover (even if I decide to collapse or expand all)</P><P></P><P>- since my column Rank is false, you can see my columns Ratio and Cumul Ratio (which accumulates the values of the column Ratio) are false too</P><P></P><P></P><P>Thanks in advance for your feedbacks,</P><P></P><P>Best regards,</P><P></P><P>Benjamin</P></BODY></HTML> Mon, 06 May 2013 13:16:33 GMT https://community.qlik.com/t5/QlikView/Problem-of-sorting-values-in-a-pivot-table-to-get-an/m-p/429145#M559452 2013-05-06T13:16:33Z Re: Problem of sorting values in a pivot table (to get an accumulation of ratio) https://community.qlik.com/t5/QlikView/Problem-of-sorting-values-in-a-pivot-table-to-get-an/m-p/429146#M559453 <HTML><HEAD></HEAD><BODY><P>sort by Y-value descendingen</P></BODY></HTML> Mon, 06 May 2013 13:47:40 GMT https://community.qlik.com/t5/QlikView/Problem-of-sorting-values-in-a-pivot-table-to-get-an/m-p/429146#M559453 2013-05-06T13:47:40Z Re: Problem of sorting values in a pivot table (to get an accumulation of ratio) https://community.qlik.com/t5/QlikView/Problem-of-sorting-values-in-a-pivot-table-to-get-an/m-p/429147#M559454 <HTML><HEAD></HEAD><BODY><P>Thanks for your answer.</P><P>But I had already tried this sorting and it doesn't work <IMG src="https://community.qlik.com/legacyfs/online/emoticons/sad.png" />.</P><P>Indeed if I sort by Y-value descending the cumul ratio is false</P></BODY></HTML> Mon, 06 May 2013 14:25:17 GMT https://community.qlik.com/t5/QlikView/Problem-of-sorting-values-in-a-pivot-table-to-get-an/m-p/429147#M559454 2013-05-06T14:25:17Z Re: Problem of sorting values in a pivot table (to get an accumulation of ratio) https://community.qlik.com/t5/QlikView/Problem-of-sorting-values-in-a-pivot-table-to-get-an/m-p/429148#M559455 <HTML><HEAD></HEAD><BODY><P>Any idea please?</P></BODY></HTML> Wed, 15 May 2013 09:14:39 GMT https://community.qlik.com/t5/QlikView/Problem-of-sorting-values-in-a-pivot-table-to-get-an/m-p/429148#M559455 2013-05-15T09:14:39Z Re: Problem of sorting values in a pivot table (to get an accumulation of ratio) https://community.qlik.com/t5/QlikView/Problem-of-sorting-values-in-a-pivot-table-to-get-an/m-p/429149#M559456 <HTML><HEAD></HEAD><BODY><P>Load the same set of data group by dimension columns with sum and sort by sum</P></BODY></HTML> Tue, 18 Jun 2013 08:49:14 GMT https://community.qlik.com/t5/QlikView/Problem-of-sorting-values-in-a-pivot-table-to-get-an/m-p/429149#M559456 skchen97 2013-06-18T08:49:14Z