topic Re: Conditional Sum Expression in QlikView https://community.qlik.com/t5/QlikView/Conditional-Sum-Expression/m-p/401328#M1149436 <HTML><HEAD></HEAD><BODY><P>figured it out!</P></BODY></HTML> Thu, 23 May 2013 16:14:43 GMT 2013-05-23T16:14:43Z Conditional Sum Expression https://community.qlik.com/t5/QlikView/Conditional-Sum-Expression/m-p/401327#M1149435 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: arial, helvetica, sans-serif;">Hi,</SPAN></P><P></P><P><SPAN style="font-family: arial, helvetica, sans-serif;">I have been trying to write a conditional sum expression and the syntax works but the numbers are wrong. </SPAN></P><P></P><P><SPAN style="font-family: arial, helvetica, sans-serif;">I have a list of Managers who each have some Preferred ("Yes") and some Not Preferred ("No") transactions. I want to sum up how much their Not Preferred spend is. When I use the below syntax, I get the TOTAL spend for the manager rather than just the Not Preferred Spend. I'm thinking it may need an "if" function somewhere but am not sure. </SPAN></P><P></P><P><SPAN style="font-family: arial, helvetica, sans-serif;">Thoughts are very appreciated!</SPAN></P><P><SPAN style="font-family: arial, helvetica, sans-serif;"><BR /></SPAN></P><P></P><P><SPAN style="font-family: arial, helvetica, sans-serif;">I have added a calculated dimension to Manager:</SPAN></P><P><SPAN style="font-family: arial, helvetica, sans-serif;">=if([Preferred]='No',[Manager])</SPAN></P><P></P><P><SPAN style="font-family: arial, helvetica, sans-serif;">My expression is: <SPAN style="color: #312e25; font-size: 11px; background-color: #f5f3e5;">Sum({$&lt;Preferred={'No'}&gt;}[Spend])</SPAN></SPAN></P><P></P><P><SPAN style="color: #312e25; font-family: monospace; font-size: 11px; background-color: #f5f3e5;"><BR /></SPAN></P></BODY></HTML> Thu, 23 May 2013 14:31:28 GMT https://community.qlik.com/t5/QlikView/Conditional-Sum-Expression/m-p/401327#M1149435 2013-05-23T14:31:28Z Re: Conditional Sum Expression https://community.qlik.com/t5/QlikView/Conditional-Sum-Expression/m-p/401328#M1149436 <HTML><HEAD></HEAD><BODY><P>figured it out!</P></BODY></HTML> Thu, 23 May 2013 16:14:43 GMT https://community.qlik.com/t5/QlikView/Conditional-Sum-Expression/m-p/401328#M1149436 2013-05-23T16:14:43Z