topic Re: if statement for 2 conditions. in QlikView https://community.qlik.com/t5/QlikView/if-statement-for-2-conditions/m-p/67181#M786373 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>If([con-type] = 2 and operator = 10, [sell-price]-[discount], "sell-price"-"discount") as [sell-price-new]</STRONG></SPAN></P></BODY></HTML> Wed, 07 Mar 2018 17:41:02 GMT sunny_talwar 2018-03-07T17:41:02Z if statement for 2 conditions. https://community.qlik.com/t5/QlikView/if-statement-for-2-conditions/m-p/67180#M786372 <HTML><HEAD></HEAD><BODY><P>I have this script</P><P></P><P>if([con-type]='2',[sell-price]-[discount],"sell-price"-"discount") as [sell-price-new]</P><P></P><P>and would like to add another condition , if operator='10' and [con-type]='2', then calculate as bove</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/if-statement-for-2-conditions/m-p/67180#M786372 dmxmikey 2020-11-25T16:16:04Z Re: if statement for 2 conditions. https://community.qlik.com/t5/QlikView/if-statement-for-2-conditions/m-p/67181#M786373 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>If([con-type] = 2 and operator = 10, [sell-price]-[discount], "sell-price"-"discount") as [sell-price-new]</STRONG></SPAN></P></BODY></HTML> Wed, 07 Mar 2018 17:41:02 GMT https://community.qlik.com/t5/QlikView/if-statement-for-2-conditions/m-p/67181#M786373 sunny_talwar 2018-03-07T17:41:02Z