topic Re: need expression with condition in QlikView https://community.qlik.com/t5/QlikView/need-expression-with-condition/m-p/1203319#M879986 <HTML><HEAD></HEAD><BODY><P>sum (&nbsp; { &lt;range={&gt;=40000}&nbsp; &gt;}&nbsp;&nbsp; sales)</P></BODY></HTML> Wed, 05 Oct 2016 15:43:34 GMT Anonymous 2016-10-05T15:43:34Z need expression with condition https://community.qlik.com/t5/QlikView/need-expression-with-condition/m-p/1203318#M879985 <HTML><HEAD></HEAD><BODY><P>creating bar chart</P><P></P><P>dimension =&nbsp; Customer Name</P><P>expression= sum(sales)</P><P></P><P><SPAN style="text-decoration: underline;">what I need</SPAN></P><P><SPAN style="text-decoration: underline;"><BR /></SPAN></P><P>&nbsp; SUM(Sales) range from 100 to 1000000</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; i need only greater than 40000 only</P><P></P><P>any one can help me please?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/need-expression-with-condition/m-p/1203318#M879985 2020-11-25T16:16:04Z Re: need expression with condition https://community.qlik.com/t5/QlikView/need-expression-with-condition/m-p/1203319#M879986 <HTML><HEAD></HEAD><BODY><P>sum (&nbsp; { &lt;range={&gt;=40000}&nbsp; &gt;}&nbsp;&nbsp; sales)</P></BODY></HTML> Wed, 05 Oct 2016 15:43:34 GMT https://community.qlik.com/t5/QlikView/need-expression-with-condition/m-p/1203319#M879986 Anonymous 2016-10-05T15:43:34Z Re: need expression with condition https://community.qlik.com/t5/QlikView/need-expression-with-condition/m-p/1203320#M879987 <HTML><HEAD></HEAD><BODY><P>May be like this:</P><P></P><P><STRONG>Sum({&lt;[Customer Name] = {"=Sum(Sales) &gt; 40000"}&gt;}Sales)</STRONG></P></BODY></HTML> Wed, 05 Oct 2016 15:45:29 GMT https://community.qlik.com/t5/QlikView/need-expression-with-condition/m-p/1203320#M879987 sunny_talwar 2016-10-05T15:45:29Z Re: need expression with condition https://community.qlik.com/t5/QlikView/need-expression-with-condition/m-p/1203321#M879988 <HTML><HEAD></HEAD><BODY><P>Or you can always do like this</P><P><STRONG>If(Sum(Sales) &gt; 40000, Sum(Sales))</STRONG></P></BODY></HTML> Wed, 05 Oct 2016 15:45:52 GMT https://community.qlik.com/t5/QlikView/need-expression-with-condition/m-p/1203321#M879988 sunny_talwar 2016-10-05T15:45:52Z Re: need expression with condition https://community.qlik.com/t5/QlikView/need-expression-with-condition/m-p/1203322#M879989 <HTML><HEAD></HEAD><BODY><P>says error in set modifier and hoc element list</P></BODY></HTML> Wed, 05 Oct 2016 15:48:09 GMT https://community.qlik.com/t5/QlikView/need-expression-with-condition/m-p/1203322#M879989 2016-10-05T15:48:09Z Re: need expression with condition https://community.qlik.com/t5/QlikView/need-expression-with-condition/m-p/1203323#M879990 <HTML><HEAD></HEAD><BODY><P>it works. thank you</P></BODY></HTML> Wed, 05 Oct 2016 15:49:24 GMT https://community.qlik.com/t5/QlikView/need-expression-with-condition/m-p/1203323#M879990 2016-10-05T15:49:24Z Re: need expression with condition https://community.qlik.com/t5/QlikView/need-expression-with-condition/m-p/1203324#M879991 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">sum (&nbsp; { &lt;range={'&gt;=40000'}&nbsp; &gt;}&nbsp;&nbsp; sales)</SPAN></P></BODY></HTML> Wed, 05 Oct 2016 15:50:22 GMT https://community.qlik.com/t5/QlikView/need-expression-with-condition/m-p/1203324#M879991 Anonymous 2016-10-05T15:50:22Z