topic Test Column(X) with a range values into IF statment in QlikView https://community.qlik.com/t5/QlikView/Test-Column-X-with-a-range-values-into-IF-statment/m-p/1183977#M1251939 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I've an issue about matching a calculated formula into a range values defined inside another table.</P><P></P><P>Please see my Testcase Qlik App. </P><P></P><P>RANK column should be works fine...</P><P></P><P>Can you help me?</P><P></P><P>Thank you very much, best regards.</P><P>Riccardo</P></BODY></HTML> Mon, 26 Jan 2026 18:19:17 GMT Riccardo 2026-01-26T18:19:17Z Test Column(X) with a range values into IF statment https://community.qlik.com/t5/QlikView/Test-Column-X-with-a-range-values-into-IF-statment/m-p/1183977#M1251939 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I've an issue about matching a calculated formula into a range values defined inside another table.</P><P></P><P>Please see my Testcase Qlik App. </P><P></P><P>RANK column should be works fine...</P><P></P><P>Can you help me?</P><P></P><P>Thank you very much, best regards.</P><P>Riccardo</P></BODY></HTML> Mon, 26 Jan 2026 18:19:17 GMT https://community.qlik.com/t5/QlikView/Test-Column-X-with-a-range-values-into-IF-statment/m-p/1183977#M1251939 Riccardo 2026-01-26T18:19:17Z Re: Test Column(X) with a range values into IF statment https://community.qlik.com/t5/QlikView/Test-Column-X-with-a-range-values-into-IF-statment/m-p/1183978#M1251943 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P><STRONG>Sum(Aggr(If(RAN_TYPE = 'COST' and Sum(Num)/100 &gt;= RAN_FROM and Sum(Num)/100 &lt;= RAN_TO, Sum(RAN_VALUE)), RAN_FROM, RAN_TO))</STRONG></P></BODY></HTML> Wed, 14 Sep 2016 16:15:21 GMT https://community.qlik.com/t5/QlikView/Test-Column-X-with-a-range-values-into-IF-statment/m-p/1183978#M1251943 sunny_talwar 2016-09-14T16:15:21Z