topic Re: Expression in QlikView https://community.qlik.com/t5/QlikView/Expression/m-p/617260#M227512 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"> if([Transaction Type]='SALESORD',-1*Quantity)</SPAN></P></BODY></HTML> Tue, 25 Mar 2014 07:26:13 GMT alexandros17 2014-03-25T07:26:13Z Expression https://community.qlik.com/t5/QlikView/Expression/m-p/617258#M227510 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>i hv Quantity field with all +ve values.</P><P>Transaction Type field there.</P><P></P><P></P><P>i want to write like if(Transaction Type='SALESORD',Quantity)...but i want to show quantity as -ve.</P><P></P><P></P><P>please help me how to do that.</P></BODY></HTML> Tue, 25 Mar 2014 07:23:41 GMT https://community.qlik.com/t5/QlikView/Expression/m-p/617258#M227510 rathnam_qv 2014-03-25T07:23:41Z Re: Expression https://community.qlik.com/t5/QlikView/Expression/m-p/617259#M227511 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"> if(Transaction Type='SALESORD',-Quantity)</SPAN></P></BODY></HTML> Tue, 25 Mar 2014 07:24:43 GMT https://community.qlik.com/t5/QlikView/Expression/m-p/617259#M227511 MK_QSL 2014-03-25T07:24:43Z Re: Expression https://community.qlik.com/t5/QlikView/Expression/m-p/617260#M227512 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"> if([Transaction Type]='SALESORD',-1*Quantity)</SPAN></P></BODY></HTML> Tue, 25 Mar 2014 07:26:13 GMT https://community.qlik.com/t5/QlikView/Expression/m-p/617260#M227512 alexandros17 2014-03-25T07:26:13Z Re: Expression https://community.qlik.com/t5/QlikView/Expression/m-p/617261#M227513 <HTML><HEAD></HEAD><BODY><P>try this as well</P><P>Sum(if(Transaction Type='SALESORD',Quantity))* -1</P><P></P><P>thanks</P><P>Michael</P></BODY></HTML> Tue, 25 Mar 2014 07:28:38 GMT https://community.qlik.com/t5/QlikView/Expression/m-p/617261#M227513 2014-03-25T07:28:38Z