topic Chart: Need help with a conditional sum in QlikView https://community.qlik.com/t5/QlikView/Chart-Need-help-with-a-conditional-sum/m-p/158430#M33512 <HTML><HEAD></HEAD><BODY><P>Perfect! Thank you!</P></BODY></HTML> Mon, 17 Aug 2009 07:24:03 GMT 2009-08-17T07:24:03Z Chart: Need help with a conditional sum https://community.qlik.com/t5/QlikView/Chart-Need-help-with-a-conditional-sum/m-p/158428#M33510 <HTML><HEAD></HEAD><BODY><P>I have a set of Order transactions. There is a transaction type that indicates whether the Order is a sale or return. I would like to create a chart that shows Returns. In other words, I would like to filter my Orders to only display the Sum of Orders where TransactionType='RP'</P><P>How would I do this?</P><P>(Thanks in advance fo your help)</P></BODY></HTML> Mon, 17 Aug 2009 00:52:51 GMT https://community.qlik.com/t5/QlikView/Chart-Need-help-with-a-conditional-sum/m-p/158428#M33510 2009-08-17T00:52:51Z Chart: Need help with a conditional sum https://community.qlik.com/t5/QlikView/Chart-Need-help-with-a-conditional-sum/m-p/158429#M33511 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>You could do this with Set analysis.</P><P>Try this ;</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;"><B>sum</B>( {$&lt;<B>TransactionType</B> = {'RP'}&gt;} <B>order</B>)</PRE></BLOCKQUOTE><BR /><BR /> <P>Best regards.</P></BODY></HTML> Mon, 17 Aug 2009 04:36:04 GMT https://community.qlik.com/t5/QlikView/Chart-Need-help-with-a-conditional-sum/m-p/158429#M33511 2009-08-17T04:36:04Z Chart: Need help with a conditional sum https://community.qlik.com/t5/QlikView/Chart-Need-help-with-a-conditional-sum/m-p/158430#M33512 <HTML><HEAD></HEAD><BODY><P>Perfect! Thank you!</P></BODY></HTML> Mon, 17 Aug 2009 07:24:03 GMT https://community.qlik.com/t5/QlikView/Chart-Need-help-with-a-conditional-sum/m-p/158430#M33512 2009-08-17T07:24:03Z