topic Expression in straight Table in QlikView https://community.qlik.com/t5/QlikView/Expression-in-straight-Table/m-p/188268#M51594 <HTML><HEAD></HEAD><BODY><P></P><P>hi</P><P></P><P>i am applying the following in and Expression</P><P>=if([Aging] = '91-120' or '121-99999', Sum (Amount))</P><P>when i apply this it return only the amount in 91-120 and the complete total.</P><P></P><P>thanks</P><P>vijay</P><BR /><BR /></BODY></HTML> Tue, 15 Dec 2009 21:53:10 GMT jagjivvt 2009-12-15T21:53:10Z Expression in straight Table https://community.qlik.com/t5/QlikView/Expression-in-straight-Table/m-p/188268#M51594 <HTML><HEAD></HEAD><BODY><P></P><P>hi</P><P></P><P>i am applying the following in and Expression</P><P>=if([Aging] = '91-120' or '121-99999', Sum (Amount))</P><P>when i apply this it return only the amount in 91-120 and the complete total.</P><P></P><P>thanks</P><P>vijay</P><BR /><BR /></BODY></HTML> Tue, 15 Dec 2009 21:53:10 GMT https://community.qlik.com/t5/QlikView/Expression-in-straight-Table/m-p/188268#M51594 jagjivvt 2009-12-15T21:53:10Z Expression in straight Table https://community.qlik.com/t5/QlikView/Expression-in-straight-Table/m-p/188269#M51595 <HTML><HEAD></HEAD><BODY><P>Hi Vijay, You need to specify the field twice for the two conditions in the if statement:</P><P>=if([Aging] = '91-120' or [Aging]='121-99999', Sum (Amount))</P><P>Depending on the data structure you might need to do Sum(If()) instead but you seem to get the correct result for Aging= 91-120 so it should work.</P></BODY></HTML> Tue, 15 Dec 2009 22:02:11 GMT https://community.qlik.com/t5/QlikView/Expression-in-straight-Table/m-p/188269#M51595 Anonymous 2009-12-15T22:02:11Z