topic How can I order custom filter? in QlikView https://community.qlik.com/t5/QlikView/How-can-I-order-custom-filter/m-p/1200146#M518942 <HTML><HEAD></HEAD><BODY><P>I have this filter:</P><P>This is my expression:</P><P>=if([Fatturato (k€)]&lt;=50000, ' &lt; 50 mln ', If(50000 &lt;&lt;[Fatturato (k€)]&gt;= 100000 , ' 50 mln &lt; &amp; &lt;100 mln', ' &gt;100 mln'))</P><P></P><P>I want order:</P><P></P><P><SPAN style="font-size: 13.3333px;"> ' &gt;100 mln'</SPAN></P><P><SPAN style="font-size: 13.3333px;">' 50 mln &lt; &amp; &lt;100 mln'</SPAN></P><P><SPAN style="font-size: 13.3333px;">' &lt; 50 mln '</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">TK </SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">NM<BR /></SPAN></P></BODY></HTML> Tue, 04 Oct 2016 09:14:38 GMT 2016-10-04T09:14:38Z How can I order custom filter? https://community.qlik.com/t5/QlikView/How-can-I-order-custom-filter/m-p/1200146#M518942 <HTML><HEAD></HEAD><BODY><P>I have this filter:</P><P>This is my expression:</P><P>=if([Fatturato (k€)]&lt;=50000, ' &lt; 50 mln ', If(50000 &lt;&lt;[Fatturato (k€)]&gt;= 100000 , ' 50 mln &lt; &amp; &lt;100 mln', ' &gt;100 mln'))</P><P></P><P>I want order:</P><P></P><P><SPAN style="font-size: 13.3333px;"> ' &gt;100 mln'</SPAN></P><P><SPAN style="font-size: 13.3333px;">' 50 mln &lt; &amp; &lt;100 mln'</SPAN></P><P><SPAN style="font-size: 13.3333px;">' &lt; 50 mln '</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">TK </SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">NM<BR /></SPAN></P></BODY></HTML> Tue, 04 Oct 2016 09:14:38 GMT https://community.qlik.com/t5/QlikView/How-can-I-order-custom-filter/m-p/1200146#M518942 2016-10-04T09:14:38Z Re: How can I order custom filter? https://community.qlik.com/t5/QlikView/How-can-I-order-custom-filter/m-p/1200147#M518943 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>=If([Fatturato (k€)] &lt;= 50000,</STRONG></SPAN></P><P><STRONG style="color: #3d3d3d; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Dual(' &lt; 50 mln ', 3),</STRONG></P><P><STRONG style="color: #3d3d3d; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">&nbsp; If(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">[Fatturato (k€)] &gt; </SPAN>50000 and [Fatturato (k€)] &gt;= 100000,</STRONG></P><P><STRONG style="color: #3d3d3d; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Dual(' 50 mln &lt; &amp; &lt;100 mln', 2),</STRONG></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Dual(' &gt;100 mln', 3)))</STRONG></SPAN></P></BODY></HTML> Tue, 04 Oct 2016 15:56:45 GMT https://community.qlik.com/t5/QlikView/How-can-I-order-custom-filter/m-p/1200147#M518943 sunny_talwar 2016-10-04T15:56:45Z