topic Need help expression syntax in QlikView https://community.qlik.com/t5/QlikView/Need-help-expression-syntax/m-p/218228#M71393 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P>if(sum(TXN_COUNT) &lt; 11, sum({$&lt;SYS_ID={'WIRES_ONLINE','ADVANCES_ONLINE'}&gt;} TXN_COUNT))</P></BODY></HTML> Thu, 09 Dec 2010 02:18:23 GMT 2010-12-09T02:18:23Z Need help expression syntax https://community.qlik.com/t5/QlikView/Need-help-expression-syntax/m-p/218227#M71392 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>So far I have</P><P></P><P><B>if</B>(<B>sum</B>(<B>TXN_COUNT</B>) &lt; 11 ,<B>sum</B>(<B>TXN_COUNT</B>))</P><DIV>which mostly does what I need it to do. I need to do something like</DIV><DIV></DIV><DIV><P style="font-weight: bold">if(sum(TXN_COUNT) &lt; 11 and SYS_ID in 'WIRES_ONLINE', 'ADVANCES_ONLINE', sum(TXN_COUNT))</P><DIV>This isn't the correct syntax but I need to show the sum of TXN_COUNT only when the SYS_ID is either one of those 2 values.</DIV><DIV></DIV><DIV>Any help would be greatly appreciated.</DIV></DIV><BR /><BR /></BODY></HTML> Thu, 09 Dec 2010 00:28:07 GMT https://community.qlik.com/t5/QlikView/Need-help-expression-syntax/m-p/218227#M71392 2010-12-09T00:28:07Z Need help expression syntax https://community.qlik.com/t5/QlikView/Need-help-expression-syntax/m-p/218228#M71393 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P>if(sum(TXN_COUNT) &lt; 11, sum({$&lt;SYS_ID={'WIRES_ONLINE','ADVANCES_ONLINE'}&gt;} TXN_COUNT))</P></BODY></HTML> Thu, 09 Dec 2010 02:18:23 GMT https://community.qlik.com/t5/QlikView/Need-help-expression-syntax/m-p/218228#M71393 2010-12-09T02:18:23Z Need help expression syntax https://community.qlik.com/t5/QlikView/Need-help-expression-syntax/m-p/218229#M71394 <HTML><HEAD></HEAD><BODY><P>Thanks - this is perfect!</P></BODY></HTML> Thu, 09 Dec 2010 14:36:23 GMT https://community.qlik.com/t5/QlikView/Need-help-expression-syntax/m-p/218229#M71394 2010-12-09T14:36:23Z