
Re: Sort values in a chart legend
Sridhar Ethiraj Feb 21, 2012 10:24 AM (in response to Aylin Bisiren )Hi,
You try using the dual function to sort you values.
IF(A >=1 and A<1.25,Dual('iinteresting',1),
if(A>=1.25 and A<2.25,Dual('empty',2),
if(A>=2.25 and A<3.25,Dual('grandfather',3),
if(A>=3.25 and A<=4,Dual('nearly',4)))))
Sort this dimension by numeric. Best way to do this is, create this as a column in back script and use the field in front end as show in this attached post.
Hope this helps you.
Sridhar

Dual Sort.qvw 129.8 K

Sort values in a chart legend
Aylin Bisiren Feb 21, 2012 10:29 AM (in response to Sridhar Ethiraj)Thanks a lot!


Sort values in a chart legend
Deepak Vadithala Feb 21, 2012 10:27 AM (in response to Aylin Bisiren )Hi,
Have you considered using Dual() function? Something like this...
=
IF(A >=1 and A<1.25, Dual('iinteresting', 1),
if(A>=1.25 and A<2.25, Dual('empty', 2),
if(A>=2.25 and A<3.25, Dual('grandfather', 3),
if(A>=3.25 and A<=4,Dual('nearly', 4)))))
Cheers  DV

Re: Sort values in a chart legend
Nathaniel Anderson Sep 18, 2014 8:26 PM (in response to Aylin Bisiren )But what if the legend doesn't represent each separate member in a dimension;
But a separate expression; i.e. sum of income, sum of bonus ;
What determines the order then?