topic Re: sum between two range in expression in QlikView https://community.qlik.com/t5/QlikView/sum-between-two-range-in-expression/m-p/427447#M159262 <HTML><HEAD></HEAD><BODY><P>Thanks Johan</P></BODY></HTML> Thu, 18 Oct 2012 11:23:11 GMT 2012-10-18T11:23:11Z sum between two range in expression https://community.qlik.com/t5/QlikView/sum-between-two-range-in-expression/m-p/427444#M159259 <HTML><HEAD></HEAD><BODY><P>I want to do summation something like sum(Actual) but with condition "company &gt;= 12001 and company &lt;= 12099"</P><P>How to write this in expression, such thing possible in QlikView</P></BODY></HTML> Thu, 18 Oct 2012 10:15:30 GMT https://community.qlik.com/t5/QlikView/sum-between-two-range-in-expression/m-p/427444#M159259 2012-10-18T10:15:30Z Re: sum between two range in expression https://community.qlik.com/t5/QlikView/sum-between-two-range-in-expression/m-p/427445#M159260 <HTML><HEAD></HEAD><BODY><P>Sum({&lt;company = {"&gt;= 12001 &lt;= 12009"}&gt;} Actual)</P></BODY></HTML> Thu, 18 Oct 2012 10:20:55 GMT https://community.qlik.com/t5/QlikView/sum-between-two-range-in-expression/m-p/427445#M159260 2012-10-18T10:20:55Z Re: sum between two range in expression https://community.qlik.com/t5/QlikView/sum-between-two-range-in-expression/m-p/427446#M159261 <HTML><HEAD></HEAD><BODY><P>Either use Sum(if(company &gt;= 12001 and company&lt;=12099, Actual))</P><P>or, Sum({$&lt;company={'&gt;=12001&lt;=12901'}&gt;} Actual)</P></BODY></HTML> Thu, 18 Oct 2012 10:21:53 GMT https://community.qlik.com/t5/QlikView/sum-between-two-range-in-expression/m-p/427446#M159261 Anonymous 2012-10-18T10:21:53Z Re: sum between two range in expression https://community.qlik.com/t5/QlikView/sum-between-two-range-in-expression/m-p/427447#M159262 <HTML><HEAD></HEAD><BODY><P>Thanks Johan</P></BODY></HTML> Thu, 18 Oct 2012 11:23:11 GMT https://community.qlik.com/t5/QlikView/sum-between-two-range-in-expression/m-p/427447#M159262 2012-10-18T11:23:11Z