topic Re: Using greater than '&gt;' to filter a measure in the script or app in App Development https://community.qlik.com/t5/App-Development/Using-greater-than-gt-to-filter-a-measure-in-the-script-or-app/m-p/127026#M8885 <HTML><HEAD></HEAD><BODY><P>Hi Rajes,</P><P></P><P>in load script your expression is valid.</P><P>Load * resident <TABLE> where Amount&gt;0;<P></P><P></P><P>On frontend you can write expression like this:</P><P>if(Amounf&gt;0,Amount,null())</P><P></P><P>then add other functions to sum, count, avg etc...</P><P></P><P>sum(if(Amounf&gt;0,Amount,null()))</P><P></P><P>G.</P></TABLE></P></BODY></HTML> Fri, 14 Sep 2018 13:48:49 GMT undergrinder 2018-09-14T13:48:49Z Using greater than '>' to filter a measure in the script or app https://community.qlik.com/t5/App-Development/Using-greater-than-gt-to-filter-a-measure-in-the-script-or-app/m-p/127025#M8884 <HTML><HEAD></HEAD><BODY><P>Hello team,</P><P></P><P>I'm trying to filter a measure like [Amount]&gt;0, this is not working for me. Please suggest me a workaround.</P><P></P><P>RaMu</P></BODY></HTML> Fri, 14 Sep 2018 03:55:24 GMT https://community.qlik.com/t5/App-Development/Using-greater-than-gt-to-filter-a-measure-in-the-script-or-app/m-p/127025#M8884 Anonymous 2018-09-14T03:55:24Z Re: Using greater than '>' to filter a measure in the script or app https://community.qlik.com/t5/App-Development/Using-greater-than-gt-to-filter-a-measure-in-the-script-or-app/m-p/127026#M8885 <HTML><HEAD></HEAD><BODY><P>Hi Rajes,</P><P></P><P>in load script your expression is valid.</P><P>Load * resident <TABLE> where Amount&gt;0;<P></P><P></P><P>On frontend you can write expression like this:</P><P>if(Amounf&gt;0,Amount,null())</P><P></P><P>then add other functions to sum, count, avg etc...</P><P></P><P>sum(if(Amounf&gt;0,Amount,null()))</P><P></P><P>G.</P></TABLE></P></BODY></HTML> Fri, 14 Sep 2018 13:48:49 GMT https://community.qlik.com/t5/App-Development/Using-greater-than-gt-to-filter-a-measure-in-the-script-or-app/m-p/127026#M8885 undergrinder 2018-09-14T13:48:49Z