topic How to do IF THEN ELSE in QlikView https://community.qlik.com/t5/QlikView/How-to-do-IF-THEN-ELSE/m-p/340623#M1175923 <HTML><HEAD></HEAD><BODY><P> Thanks Vincent for your help</P></BODY></HTML> Wed, 09 May 2012 04:24:12 GMT 2012-05-09T04:24:12Z How to do IF THEN ELSE https://community.qlik.com/t5/QlikView/How-to-do-IF-THEN-ELSE/m-p/340619#M1175919 <HTML><HEAD></HEAD><BODY><P>Hello Everybody,</P><P>&nbsp; </P><P>Can anyone please help me to get the "COST" right ?</P><P></P><P>Many Thanks In advance</P><P></P><P>IF LEFT(DESC, 3) = "SRT" THEN (UNITCOST * QTYSHIPPED) * -1 </P><P></P><P>ELSE FCSTSALES</P><P>AS COST; </P><P></P><P></P><P></P><P>Kind Regards</P><P>Aamir</P></BODY></HTML> Tue, 08 May 2012 05:40:43 GMT https://community.qlik.com/t5/QlikView/How-to-do-IF-THEN-ELSE/m-p/340619#M1175919 2012-05-08T05:40:43Z Re: How to do IF THEN ELSE https://community.qlik.com/t5/QlikView/How-to-do-IF-THEN-ELSE/m-p/340620#M1175920 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try : <SPAN style="font-family: courier new,courier;">if(left(DESC,3)='SRT',(UNITCOST*QTYSHIPPED)*-1,FCSTSALES)</SPAN></P><P></P><P>Regards,</P><P>Vincent</P></BODY></HTML> Tue, 08 May 2012 06:19:25 GMT https://community.qlik.com/t5/QlikView/How-to-do-IF-THEN-ELSE/m-p/340620#M1175920 vincent_ardiet 2012-05-08T06:19:25Z How to do IF THEN ELSE https://community.qlik.com/t5/QlikView/How-to-do-IF-THEN-ELSE/m-p/340621#M1175921 <HTML><HEAD></HEAD><BODY><P>use below in script editor</P><P></P><P><SPAN style="color: #636363; font-family: Arial; font-size: 12px; background-color: #ffffff;"> </SPAN><SPAN style="background-color: #ffffff; font-size: 12px; color: #636363; font-family: 'courier new', courier;">if(left(DESC,3)='SRT',(UNITCOST*QTYSHIPPED)*-1,FCSTSALES)&nbsp; as <SPAN style="color: #636363; font-family: Arial; font-size: 12px; background-color: #eef4f9;">COST&nbsp;&nbsp; </SPAN></SPAN></P><P></P><P></P><P>hope this helps</P><P></P><P><SPAN style="color: #636363; font-size: 12px; background-color: #eef4f9; font-family: Arial;"> <BR /></SPAN></P></BODY></HTML> Tue, 08 May 2012 06:21:54 GMT https://community.qlik.com/t5/QlikView/How-to-do-IF-THEN-ELSE/m-p/340621#M1175921 SunilChauhan 2012-05-08T06:21:54Z How to do IF THEN ELSE https://community.qlik.com/t5/QlikView/How-to-do-IF-THEN-ELSE/m-p/340622#M1175922 <HTML><HEAD></HEAD><BODY><P>Thank you so much Sunil</P><P></P><P>Aamir</P></BODY></HTML> Wed, 09 May 2012 04:22:38 GMT https://community.qlik.com/t5/QlikView/How-to-do-IF-THEN-ELSE/m-p/340622#M1175922 2012-05-09T04:22:38Z How to do IF THEN ELSE https://community.qlik.com/t5/QlikView/How-to-do-IF-THEN-ELSE/m-p/340623#M1175923 <HTML><HEAD></HEAD><BODY><P> Thanks Vincent for your help</P></BODY></HTML> Wed, 09 May 2012 04:24:12 GMT https://community.qlik.com/t5/QlikView/How-to-do-IF-THEN-ELSE/m-p/340623#M1175923 2012-05-09T04:24:12Z