topic Sort by Y-Axis programmatically in QlikView https://community.qlik.com/t5/QlikView/Sort-by-Y-Axis-programmatically/m-p/601873#M1113449 <HTML><HEAD></HEAD><BODY><P>Hi - </P><P></P><P>I am building a stacked bar-chart with a user toggle between sort-alphabetically and sort-by-total descending.&nbsp; The problem is when the Y-axis has multiple elements then this sort statement ...</P><P></P><P style="padding-left: 30px;"><SPAN style="font-family: 'courier new', courier;"><STRONG>=if(vSortByCaption='Name',vXAxis_col,-1 * $(=vFormula))</STRONG></SPAN></P><P></P><P>... results in a sort by the largest single Y element, not the Y total.; but if I turn on "Sort by Y-Axis" then I lose the ability to sort alphabetically.&nbsp; See attached screenshot below.</P><P></P><P>Is there a better way to code the sort expression or else to programatically toggle the "Sort by Y-Axis" checkbox?</P><P></P><P>Thank you</P><P></P><P><IMG alt="Sort-by-value.PNG.png" class="jive-image jiveImage" src="https://community.qlik.com/legacyfs/online/53429_Sort-by-value.PNG.png" /></P></BODY></HTML> Tue, 18 Feb 2014 16:07:17 GMT 2014-02-18T16:07:17Z Sort by Y-Axis programmatically https://community.qlik.com/t5/QlikView/Sort-by-Y-Axis-programmatically/m-p/601873#M1113449 <HTML><HEAD></HEAD><BODY><P>Hi - </P><P></P><P>I am building a stacked bar-chart with a user toggle between sort-alphabetically and sort-by-total descending.&nbsp; The problem is when the Y-axis has multiple elements then this sort statement ...</P><P></P><P style="padding-left: 30px;"><SPAN style="font-family: 'courier new', courier;"><STRONG>=if(vSortByCaption='Name',vXAxis_col,-1 * $(=vFormula))</STRONG></SPAN></P><P></P><P>... results in a sort by the largest single Y element, not the Y total.; but if I turn on "Sort by Y-Axis" then I lose the ability to sort alphabetically.&nbsp; See attached screenshot below.</P><P></P><P>Is there a better way to code the sort expression or else to programatically toggle the "Sort by Y-Axis" checkbox?</P><P></P><P>Thank you</P><P></P><P><IMG alt="Sort-by-value.PNG.png" class="jive-image jiveImage" src="https://community.qlik.com/legacyfs/online/53429_Sort-by-value.PNG.png" /></P></BODY></HTML> Tue, 18 Feb 2014 16:07:17 GMT https://community.qlik.com/t5/QlikView/Sort-by-Y-Axis-programmatically/m-p/601873#M1113449 2014-02-18T16:07:17Z Re: Sort by Y-Axis programmatically https://community.qlik.com/t5/QlikView/Sort-by-Y-Axis-programmatically/m-p/601874#M1113450 <HTML><HEAD></HEAD><BODY><P>if I understand your question you can try to sort by</P><P>aggr(sum(Value), MonthData)</P><P>where Value is expression and MonthData is your first dimension</P><P>see attachment</P></BODY></HTML> Tue, 18 Feb 2014 18:53:19 GMT https://community.qlik.com/t5/QlikView/Sort-by-Y-Axis-programmatically/m-p/601874#M1113450 maxgro 2014-02-18T18:53:19Z