topic If Statements in Expressions in QlikView https://community.qlik.com/t5/QlikView/If-Statements-in-Expressions/m-p/181293#M47376 <HTML><HEAD></HEAD><BODY><P>= SUM( IF( emptype = 'A' OR emptype = 'W', cost) )</P></BODY></HTML> Wed, 09 Dec 2009 18:53:26 GMT 2009-12-09T18:53:26Z If Statements in Expressions https://community.qlik.com/t5/QlikView/If-Statements-in-Expressions/m-p/181292#M47375 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P></P><P>is there a way of using if statements in expressions to total up 2 value types e.g</P><P>my tables are</P><P>emp.type, where there are A S and W and another table has values for each emp.type. what i am trying to do is work out the cost of each emp type and display on straight table.</P><P></P><P></P><P>thank</P><P></P></BODY></HTML> Wed, 09 Dec 2009 18:18:00 GMT https://community.qlik.com/t5/QlikView/If-Statements-in-Expressions/m-p/181292#M47375 jagjivvt 2009-12-09T18:18:00Z If Statements in Expressions https://community.qlik.com/t5/QlikView/If-Statements-in-Expressions/m-p/181293#M47376 <HTML><HEAD></HEAD><BODY><P>= SUM( IF( emptype = 'A' OR emptype = 'W', cost) )</P></BODY></HTML> Wed, 09 Dec 2009 18:53:26 GMT https://community.qlik.com/t5/QlikView/If-Statements-in-Expressions/m-p/181293#M47376 2009-12-09T18:53:26Z