https://community.qlik.com/t5/App-Development/Number-with-decimals-comparison/m-p/1606590#M44933 <P>Share your expression</P> Fri, 26 Jul 2019 16:07:00 GMT dplr-rn 2019-07-26T16:07:00Z https://community.qlik.com/t5/App-Development/Number-with-decimals-comparison/m-p/1606584#M44931 <P>I am trying to do a expression where numbers should be greater than and less than expression.&nbsp; For example , I am trying to filter numbers which are greater than 7 and less than 14. But for some reason, I am getting some values out of range. For example, I see result with 14.5</P> Fri, 26 Jul 2019 15:55:04 GMT https://community.qlik.com/t5/App-Development/Number-with-decimals-comparison/m-p/1606584#M44931 mel78 2019-07-26T15:55:04Z https://community.qlik.com/t5/App-Development/Number-with-decimals-comparison/m-p/1606590#M44933 <P>Share your expression</P> Fri, 26 Jul 2019 16:07:00 GMT https://community.qlik.com/t5/App-Development/Number-with-decimals-comparison/m-p/1606590#M44933 dplr-rn 2019-07-26T16:07:00Z https://community.qlik.com/t5/App-Development/Number-with-decimals-comparison/m-p/1607017#M45006 <P>"Aggr(Median({1&lt;$(vFilters)&gt;}&nbsp; FieldNameXXX), FieldName) &gt;= VFrom AND Aggr(Median({1&lt;$(vFilters)&gt;} <SPAN>FieldNameXXX</SPAN>), <SPAN>FieldName</SPAN>) &lt;= vTo"</P><P>The weird things is that 7 to 14 gives me 14.5 , but 7 to 15 works fine.</P><P>&nbsp;</P> Mon, 29 Jul 2019 13:01:06 GMT https://community.qlik.com/t5/App-Development/Number-with-decimals-comparison/m-p/1607017#M45006 mel78 2019-07-29T13:01:06Z