topic Re: How to put if expression? in QlikView https://community.qlik.com/t5/QlikView/How-to-put-if-expression/m-p/360565#M1169715 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P>if(ComparisonContract &gt; MKT3, </P><P> "Expensive",</P><P> if(ComparisonContract &lt; MKT1,</P><P>&nbsp; "Cheapest",</P><P>&nbsp; "-"</P><P> )</P><P>)</P></BODY></HTML> Fri, 20 Jul 2012 14:10:05 GMT mphekin12 2012-07-20T14:10:05Z How to put if expression? https://community.qlik.com/t5/QlikView/How-to-put-if-expression/m-p/360563#M1169713 <HTML><HEAD></HEAD><BODY><P>Hello There,</P><P></P><P>How to write If condition in below condition</P><P></P><P><STRONG style="font-size: 10.0pt; font-family: 'Tahoma','sans-serif';">IF Comparison Contract &gt; MKT3, “EXPENSIVE”. IF Comparison Contract &lt; MKT1, “CHEAPEST”. If none of the previous, “-“</STRONG></P><P></P><P><STRONG style="font-size: 10.0pt; font-family: 'Tahoma','sans-serif';">Thanks,</STRONG></P><P><STRONG style="font-size: 10.0pt; font-family: 'Tahoma','sans-serif';">Siva<BR /></STRONG></P></BODY></HTML> Fri, 20 Jul 2012 14:04:26 GMT https://community.qlik.com/t5/QlikView/How-to-put-if-expression/m-p/360563#M1169713 siva_boggarapu 2012-07-20T14:04:26Z Re: How to put if expression? https://community.qlik.com/t5/QlikView/How-to-put-if-expression/m-p/360564#M1169714 <HTML><HEAD></HEAD><BODY><P>if([Comparison Contract]&gt;[MKT3], "EXPENSIVE",</P><P>if([Comparison Contract]&lt;[MKT1], "CHEAPEST",</P><P>"-"</P><P>))</P></BODY></HTML> Fri, 20 Jul 2012 14:07:21 GMT https://community.qlik.com/t5/QlikView/How-to-put-if-expression/m-p/360564#M1169714 2012-07-20T14:07:21Z Re: How to put if expression? https://community.qlik.com/t5/QlikView/How-to-put-if-expression/m-p/360565#M1169715 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P>if(ComparisonContract &gt; MKT3, </P><P> "Expensive",</P><P> if(ComparisonContract &lt; MKT1,</P><P>&nbsp; "Cheapest",</P><P>&nbsp; "-"</P><P> )</P><P>)</P></BODY></HTML> Fri, 20 Jul 2012 14:10:05 GMT https://community.qlik.com/t5/QlikView/How-to-put-if-expression/m-p/360565#M1169715 mphekin12 2012-07-20T14:10:05Z