topic Re: Need Expression to exclude 2 types in sum If expression in QlikView https://community.qlik.com/t5/QlikView/Need-Expression-to-exclude-2-types-in-sum-If-expression/m-p/552872#M206584 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #737373; font-family: 'arial black', 'avant garde'; background-color: #ffffff; font-size: 12pt;">Sum ({&lt;SaleType-={'Pontoons','Engines'}&gt;} SalesDollars)</SPAN></P></BODY></HTML> Mon, 08 Jul 2013 20:36:59 GMT 2013-07-08T20:36:59Z Need Expression to exclude 2 types in sum If expression https://community.qlik.com/t5/QlikView/Need-Expression-to-exclude-2-types-in-sum-If-expression/m-p/552870#M206582 <HTML><HEAD></HEAD><BODY><P>I am trying to use an expression to sum sales for everyting except to types</P><P>Sum (if(SaleType &lt;&gt; 'Pontoons' or 'Engines', SalesDollars)</P><P>It's excluding the Pontoons but not the Engines</P><P></P><P>How do I write this expression to work properly</P></BODY></HTML> Mon, 08 Jul 2013 20:14:56 GMT https://community.qlik.com/t5/QlikView/Need-Expression-to-exclude-2-types-in-sum-If-expression/m-p/552870#M206582 suepenick 2013-07-08T20:14:56Z Re: Need Expression to exclude 2 types in sum If expression https://community.qlik.com/t5/QlikView/Need-Expression-to-exclude-2-types-in-sum-If-expression/m-p/552871#M206583 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>Try this</P><P></P><P><SPAN style="font-size: 9pt; font-family: 'Courier New'; color: blue;">Sum</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New'; color: black;">( {$-&lt;</SPAN>SaleType<SPAN style="font-size: 9pt; font-family: 'Courier New'; color: black;">={'</SPAN>Pontoons<SPAN style="font-size: 9pt; font-family: 'Courier New'; color: black;">'}&gt;-&lt;</SPAN>SaleType<SPAN style="font-size: 9pt; font-family: 'Courier New'; color: black;">={'</SPAN>Engines<SPAN style="font-size: 9pt; font-family: 'Courier New'; color: black;">'}&gt; } </SPAN>SalesDollars<SPAN style="font-size: 9pt; font-family: 'Courier New'; color: black;">) </SPAN></P><P></P><P><SPAN style="font-size: 9pt; font-family: 'Courier New'; color: black;">Cheers,</SPAN></P><P></P><P><SPAN style="font-size: 9pt; font-family: 'Courier New'; color: black;">JuanD<BR /></SPAN></P></BODY></HTML> Mon, 08 Jul 2013 20:26:55 GMT https://community.qlik.com/t5/QlikView/Need-Expression-to-exclude-2-types-in-sum-If-expression/m-p/552871#M206583 2013-07-08T20:26:55Z Re: Need Expression to exclude 2 types in sum If expression https://community.qlik.com/t5/QlikView/Need-Expression-to-exclude-2-types-in-sum-If-expression/m-p/552872#M206584 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #737373; font-family: 'arial black', 'avant garde'; background-color: #ffffff; font-size: 12pt;">Sum ({&lt;SaleType-={'Pontoons','Engines'}&gt;} SalesDollars)</SPAN></P></BODY></HTML> Mon, 08 Jul 2013 20:36:59 GMT https://community.qlik.com/t5/QlikView/Need-Expression-to-exclude-2-types-in-sum-If-expression/m-p/552872#M206584 2013-07-08T20:36:59Z Re: Need Expression to exclude 2 types in sum If expression https://community.qlik.com/t5/QlikView/Need-Expression-to-exclude-2-types-in-sum-If-expression/m-p/552873#M206585 <HTML><HEAD></HEAD><BODY><P>Thanks - it worked - I don't have a clue why - but maybe I'll understand what all the symbols are for!</P></BODY></HTML> Mon, 08 Jul 2013 20:39:59 GMT https://community.qlik.com/t5/QlikView/Need-Expression-to-exclude-2-types-in-sum-If-expression/m-p/552873#M206585 suepenick 2013-07-08T20:39:59Z Re: Need Expression to exclude 2 types in sum If expression https://community.qlik.com/t5/QlikView/Need-Expression-to-exclude-2-types-in-sum-If-expression/m-p/552874#M206586 <HTML><HEAD></HEAD><BODY><P>This one did not work - I tried that from Chapter 11 in the Qlikview 11 book</P></BODY></HTML> Mon, 08 Jul 2013 20:40:47 GMT https://community.qlik.com/t5/QlikView/Need-Expression-to-exclude-2-types-in-sum-If-expression/m-p/552874#M206586 suepenick 2013-07-08T20:40:47Z