topic Re: Expression Syntax in QlikView https://community.qlik.com/t5/QlikView/Expression-Syntax/m-p/397280#M484381 <HTML><HEAD></HEAD><BODY><P>Maybe</P><P></P><P>sum(if(Category = 'B' or Category = 'O', Amount))</P><P></P><P>resp.</P><P></P><P>sum({&lt;Category = {'B','O'}&gt;} Amount)</P></BODY></HTML> Wed, 22 May 2013 19:54:46 GMT swuehl 2013-05-22T19:54:46Z Expression Syntax https://community.qlik.com/t5/QlikView/Expression-Syntax/m-p/397279#M484380 <HTML><HEAD></HEAD><BODY><P>My data contains two columns: Amount and Category. The category column has three options: B, C, and O. I would like to add an expression that would only look at the sum for category "B" or "O" or both "B+O". I am looking for some help with the syntax</P></BODY></HTML> Wed, 22 May 2013 19:30:56 GMT https://community.qlik.com/t5/QlikView/Expression-Syntax/m-p/397279#M484380 2013-05-22T19:30:56Z Re: Expression Syntax https://community.qlik.com/t5/QlikView/Expression-Syntax/m-p/397280#M484381 <HTML><HEAD></HEAD><BODY><P>Maybe</P><P></P><P>sum(if(Category = 'B' or Category = 'O', Amount))</P><P></P><P>resp.</P><P></P><P>sum({&lt;Category = {'B','O'}&gt;} Amount)</P></BODY></HTML> Wed, 22 May 2013 19:54:46 GMT https://community.qlik.com/t5/QlikView/Expression-Syntax/m-p/397280#M484381 swuehl 2013-05-22T19:54:46Z