topic IF [Field_1] &gt; [Field_2] then... in the script in QlikView https://community.qlik.com/t5/QlikView/IF-Field-1-gt-Field-2-then-in-the-script/m-p/971109#M332452 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>How i can compare the value of two field in the script,</P><P></P><P>i want to do : IF( [Field_1] &gt; [Field_2] then 'Value' ) as new_field.</P><P></P><P></P><P>Thanks </P></BODY></HTML> Thu, 17 Sep 2015 12:07:08 GMT 2015-09-17T12:07:08Z IF [Field_1] > [Field_2] then... in the script https://community.qlik.com/t5/QlikView/IF-Field-1-gt-Field-2-then-in-the-script/m-p/971109#M332452 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>How i can compare the value of two field in the script,</P><P></P><P>i want to do : IF( [Field_1] &gt; [Field_2] then 'Value' ) as new_field.</P><P></P><P></P><P>Thanks </P></BODY></HTML> Thu, 17 Sep 2015 12:07:08 GMT https://community.qlik.com/t5/QlikView/IF-Field-1-gt-Field-2-then-in-the-script/m-p/971109#M332452 2015-09-17T12:07:08Z Re: IF [Field_1] > [Field_2] then... in the script https://community.qlik.com/t5/QlikView/IF-Field-1-gt-Field-2-then-in-the-script/m-p/971110#M332453 <HTML><HEAD></HEAD><BODY><P>Then you could use:</P><P></P><P>IF([Field_1] &gt; [Field_2], 'Value', 'SomeOtherValue' ) as new_field</P><P></P><P>- Marcus</P></BODY></HTML> Thu, 17 Sep 2015 12:10:14 GMT https://community.qlik.com/t5/QlikView/IF-Field-1-gt-Field-2-then-in-the-script/m-p/971110#M332453 marcus_sommer 2015-09-17T12:10:14Z Re: IF [Field_1] > [Field_2] then... in the script https://community.qlik.com/t5/QlikView/IF-Field-1-gt-Field-2-then-in-the-script/m-p/971111#M332454 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Please try this one:</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">IF( [Field_1] &gt; [Field_2] , 'Value' )&nbsp; as new_field</SPAN></P></BODY></HTML> Thu, 17 Sep 2015 12:12:25 GMT https://community.qlik.com/t5/QlikView/IF-Field-1-gt-Field-2-then-in-the-script/m-p/971111#M332454 raghvendrasingh 2015-09-17T12:12:25Z Re: IF [Field_1] > [Field_2] then... in the script https://community.qlik.com/t5/QlikView/IF-Field-1-gt-Field-2-then-in-the-script/m-p/971112#M332455 <HTML><HEAD></HEAD><BODY><P>Thanks a lot Guys. </P></BODY></HTML> Thu, 17 Sep 2015 12:42:56 GMT https://community.qlik.com/t5/QlikView/IF-Field-1-gt-Field-2-then-in-the-script/m-p/971112#M332455 2015-09-17T12:42:56Z