https://community.qlik.com/t5/App-Development/Coloring-by-dimension-and-ordering-legend/m-p/1681997#M51922 <P>Hello</P><P>In a bar chart, I order dimension using expression like this : if(Match(mydimension,'US'),1,if(Match(mydimension,'FR'),2, ...))</P><P>It works fine.</P><P>But when I configure color by dimension using 'mydimension', the different values of mydimension are listed in alphabetical order, and no more using expression.</P><P>Any idea to resolve this problem?</P><P>Thanks!</P> Thu, 05 Mar 2020 10:32:19 GMT jleberre 2020-03-05T10:32:19Z https://community.qlik.com/t5/App-Development/Coloring-by-dimension-and-ordering-legend/m-p/1681997#M51922 <P>Hello</P><P>In a bar chart, I order dimension using expression like this : if(Match(mydimension,'US'),1,if(Match(mydimension,'FR'),2, ...))</P><P>It works fine.</P><P>But when I configure color by dimension using 'mydimension', the different values of mydimension are listed in alphabetical order, and no more using expression.</P><P>Any idea to resolve this problem?</P><P>Thanks!</P> Thu, 05 Mar 2020 10:32:19 GMT https://community.qlik.com/t5/App-Development/Coloring-by-dimension-and-ordering-legend/m-p/1681997#M51922 jleberre 2020-03-05T10:32:19Z https://community.qlik.com/t5/App-Development/Coloring-by-dimension-and-ordering-legend/m-p/1682011#M51925 <P>I finally resolved my problem using Dual(text,number) function</P><P>My field has&nbsp; now 2 values: a string value for display purposes, and a number value for sorting purposes</P><P>Dimension is ordered by number instead of by expression</P><P>&nbsp;</P> Thu, 05 Mar 2020 11:18:11 GMT https://community.qlik.com/t5/App-Development/Coloring-by-dimension-and-ordering-legend/m-p/1682011#M51925 jleberre 2020-03-05T11:18:11Z