topic Please help me with the if statement below in QlikView https://community.qlik.com/t5/QlikView/Please-help-me-with-the-if-statement-below/m-p/613308#M1113543 <HTML><HEAD></HEAD><BODY><P>How can I write this in Qlikview.Please help me.</P><P></P><P>IIf(RTL_TERMS.TRMN_DT Is Null AND DATEDIFF("YYYY",QRYALL_RTL_WRK_ENDPOP.HIR_DT,QRYALL_RTL_WRK_ENDPOP.AS_OF_DT)*12+DATEDIFF("M",QRYALL_RTL_WRK_ENDPOP.HIR_DT,QRYALL_RTL_WRK_ENDPOP.AS_OF_DT) BETWEEN&nbsp; 0 AND 6, "011401",</P><P></P><P>IIf(RTL_TERMS.TRMN_DT Is Not Null AND&nbsp; DATEDIFF("YYYY",QRYALL_RTL_WRK_ENDPOP.HIR_DT,RTL_TERMS.TRMN_DT)*12+DATEDIFF("M",QRYALL_RTL_WRK_ENDPOP.HIR_DT,RTL_TERMS.TRMN_DT) BETWEEN&nbsp; 0 AND 6, "011401", "None"))) as Tenure</P><P></P><P>Thanks in advance.</P></BODY></HTML> Thu, 20 Feb 2014 15:31:22 GMT 2014-02-20T15:31:22Z Please help me with the if statement below https://community.qlik.com/t5/QlikView/Please-help-me-with-the-if-statement-below/m-p/613308#M1113543 <HTML><HEAD></HEAD><BODY><P>How can I write this in Qlikview.Please help me.</P><P></P><P>IIf(RTL_TERMS.TRMN_DT Is Null AND DATEDIFF("YYYY",QRYALL_RTL_WRK_ENDPOP.HIR_DT,QRYALL_RTL_WRK_ENDPOP.AS_OF_DT)*12+DATEDIFF("M",QRYALL_RTL_WRK_ENDPOP.HIR_DT,QRYALL_RTL_WRK_ENDPOP.AS_OF_DT) BETWEEN&nbsp; 0 AND 6, "011401",</P><P></P><P>IIf(RTL_TERMS.TRMN_DT Is Not Null AND&nbsp; DATEDIFF("YYYY",QRYALL_RTL_WRK_ENDPOP.HIR_DT,RTL_TERMS.TRMN_DT)*12+DATEDIFF("M",QRYALL_RTL_WRK_ENDPOP.HIR_DT,RTL_TERMS.TRMN_DT) BETWEEN&nbsp; 0 AND 6, "011401", "None"))) as Tenure</P><P></P><P>Thanks in advance.</P></BODY></HTML> Thu, 20 Feb 2014 15:31:22 GMT https://community.qlik.com/t5/QlikView/Please-help-me-with-the-if-statement-below/m-p/613308#M1113543 2014-02-20T15:31:22Z Re: Please help me with the if statement below https://community.qlik.com/t5/QlikView/Please-help-me-with-the-if-statement-below/m-p/613309#M1113545 <HTML><HEAD></HEAD><BODY><P>Hi.</P><P></P><P>Maybe like this:</P><P>If(not isnull(RTL_TERMS.TRMN_DT) and rangemax(12*(year(QRYALL_RTL_WRK_ENDPOP.HIR_DT)-year(RTL_TERMS.TRMN_DT)) + month(QRYALL_RTL_WRK_ENDPOP.HIR_DT)-month(RTL_TERMS.TRMN_DT),0)&gt;=6, '022401', 'None') as Tenure</P><P></P><P>Or</P><P></P><P>If(not isnull(RTL_TERMS.TRMN_DT) and addmonths(QRYALL_RTL_WRK_ENDPOP.HIR_DT, -6) &lt;=&nbsp; RTL_TERMS.TRMN_DT , '022401', 'None') as Tenure&nbsp; </P></BODY></HTML> Thu, 20 Feb 2014 18:27:54 GMT https://community.qlik.com/t5/QlikView/Please-help-me-with-the-if-statement-below/m-p/613309#M1113545 whiteline 2014-02-20T18:27:54Z