topic Create a New Field in QlikView https://community.qlik.com/t5/QlikView/Create-a-New-Field/m-p/1365573#M825246 <HTML><HEAD></HEAD><BODY><P>Hi Community,</P><P></P><P>Just need your help to add a Conditional field in qlikview.</P><P></P><P>Two Existing Fields:</P><P>Agreed Date </P><P>Completed Date</P><P></P><P>New Field: </P><P>If Completed Date &lt;= Agreed Date then "MET"</P><P>If Completed Date &gt; Agreed Date then "MISS"</P><P></P><P>Thank you.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT 2020-11-25T16:16:04Z Create a New Field https://community.qlik.com/t5/QlikView/Create-a-New-Field/m-p/1365573#M825246 <HTML><HEAD></HEAD><BODY><P>Hi Community,</P><P></P><P>Just need your help to add a Conditional field in qlikview.</P><P></P><P>Two Existing Fields:</P><P>Agreed Date </P><P>Completed Date</P><P></P><P>New Field: </P><P>If Completed Date &lt;= Agreed Date then "MET"</P><P>If Completed Date &gt; Agreed Date then "MISS"</P><P></P><P>Thank you.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Create-a-New-Field/m-p/1365573#M825246 2020-11-25T16:16:04Z Re: Create a New Field https://community.qlik.com/t5/QlikView/Create-a-New-Field/m-p/1365574#M825247 <HTML><HEAD></HEAD><BODY><P>Should be simple. Try</P><PRE __default_attr="sql" __jive_macro_name="code" class="jive_macro_code _jivemacro_uid_14997871103986357 jive_text_macro" jivemacro_uid="_14997871103986357"> <P><SPAN style="font-family: monospace; font-size: 13.3333px;">If([</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Completed Date] &lt;= [Agreed Date], 'MET', 'MISS'</SPAN><SPAN style="font-family: monospace; font-size: 13.3333px;">)&nbsp;&nbsp;&nbsp; as NewField</SPAN></P> </PRE></BODY></HTML> Tue, 11 Jul 2017 15:32:25 GMT https://community.qlik.com/t5/QlikView/Create-a-New-Field/m-p/1365574#M825247 juraj_misina 2017-07-11T15:32:25Z