topic Showing table with data between two values in QlikView https://community.qlik.com/t5/QlikView/Showing-table-with-data-between-two-values/m-p/214933#M68429 <HTML><HEAD></HEAD><BODY><P>Great - thankyou!! I have used the basis of the formula to fit what I need to do and i works!</P></BODY></HTML> Mon, 18 Jan 2010 16:19:51 GMT Anonymous 2010-01-18T16:19:51Z Showing table with data between two values https://community.qlik.com/t5/QlikView/Showing-table-with-data-between-two-values/m-p/214931#M68427 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I have a simple table showing our customers and the total value of invoices but I would like to limit the data to show customers who brought between 1gbp and 1000gbp value of goods thus cutting the rest out.</P><P>I have two fields in my dimension customer and their account number and an expression which is sum(val). Val is my total value of invoices.</P><P></P><P>Any help greatly appreciated!!</P><P>Thanks</P><P>Sagar</P><P></P><P></P><P></P></BODY></HTML> Mon, 18 Jan 2010 11:13:13 GMT https://community.qlik.com/t5/QlikView/Showing-table-with-data-between-two-values/m-p/214931#M68427 Anonymous 2010-01-18T11:13:13Z Showing table with data between two values https://community.qlik.com/t5/QlikView/Showing-table-with-data-between-two-values/m-p/214932#M68428 <HTML><HEAD></HEAD><BODY><P>Hello Sagar,</P><P>You can use a conditional expression like (untested)</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">IF(SUM(VAL) &gt; 1 AND SUM(VAL) &lt; 1000, SUM(VAL))</PRE></BLOCKQUOTE><BR /><BR /></BODY></HTML> Mon, 18 Jan 2010 12:09:16 GMT https://community.qlik.com/t5/QlikView/Showing-table-with-data-between-two-values/m-p/214932#M68428 Miguel_Angel_Baeyens 2010-01-18T12:09:16Z Showing table with data between two values https://community.qlik.com/t5/QlikView/Showing-table-with-data-between-two-values/m-p/214933#M68429 <HTML><HEAD></HEAD><BODY><P>Great - thankyou!! I have used the basis of the formula to fit what I need to do and i works!</P></BODY></HTML> Mon, 18 Jan 2010 16:19:51 GMT https://community.qlik.com/t5/QlikView/Showing-table-with-data-between-two-values/m-p/214933#M68429 Anonymous 2010-01-18T16:19:51Z