topic Re: If expression in QlikView https://community.qlik.com/t5/QlikView/If-expression/m-p/533325#M1129415 <HTML><HEAD></HEAD><BODY><P>You could be able to find my mail id in my profile. If you got what you required, please close it by marking it as correct answer. So that it will help others not to work on same question.</P></BODY></HTML> Thu, 05 Dec 2013 13:53:56 GMT manideep78 2013-12-05T13:53:56Z If expression https://community.qlik.com/t5/QlikView/If-expression/m-p/533321#M1129411 <HTML><HEAD></HEAD><BODY><P><BR />Hi ,</P><P></P><P>Please tell the expression ..I have a 'Sales Type' field in which it contains 'Units',&nbsp; 'Cash'...Now i want to calculate 'IPSales'</P><P>Ex: sales type= units ,i want sum of IPSales ...</P><P>Please give the expression in IF statement and Set analysis also......</P></BODY></HTML> Thu, 05 Dec 2013 13:31:00 GMT https://community.qlik.com/t5/QlikView/If-expression/m-p/533321#M1129411 polisetti 2013-12-05T13:31:00Z Re: If expression https://community.qlik.com/t5/QlikView/If-expression/m-p/533322#M1129412 <HTML><HEAD></HEAD><BODY><P>Set Analysis:</P><P></P><P>Sum({&lt;[<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12.727272033691406px;">Sales Type</SPAN>]={units}&gt;}<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12.727272033691406px;">IPSales</SPAN>)</P><P></P><P>Script:</P><P></P><P>Sum(If([<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12.727272033691406px;">Sales Type</SPAN>]={units}, <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12.727272033691406px;">IPSales</SPAN>)) as IPSalesSum</P></BODY></HTML> Thu, 05 Dec 2013 13:34:45 GMT https://community.qlik.com/t5/QlikView/If-expression/m-p/533322#M1129412 manideep78 2013-12-05T13:34:45Z Re: If expression https://community.qlik.com/t5/QlikView/If-expression/m-p/533323#M1129413 <HTML><HEAD></HEAD><BODY><P>Thank you Manideep</P></BODY></HTML> Thu, 05 Dec 2013 13:41:27 GMT https://community.qlik.com/t5/QlikView/If-expression/m-p/533323#M1129413 polisetti 2013-12-05T13:41:27Z Re: If expression https://community.qlik.com/t5/QlikView/If-expression/m-p/533324#M1129414 <HTML><HEAD></HEAD><BODY><P>If possible please give you mail&nbsp; id ...</P></BODY></HTML> Thu, 05 Dec 2013 13:44:43 GMT https://community.qlik.com/t5/QlikView/If-expression/m-p/533324#M1129414 polisetti 2013-12-05T13:44:43Z Re: If expression https://community.qlik.com/t5/QlikView/If-expression/m-p/533325#M1129415 <HTML><HEAD></HEAD><BODY><P>You could be able to find my mail id in my profile. If you got what you required, please close it by marking it as correct answer. So that it will help others not to work on same question.</P></BODY></HTML> Thu, 05 Dec 2013 13:53:56 GMT https://community.qlik.com/t5/QlikView/If-expression/m-p/533325#M1129415 manideep78 2013-12-05T13:53:56Z