topic IF(Datefield = Max(OtherDateField), ... in QlikView https://community.qlik.com/t5/QlikView/IF-Datefield-Max-OtherDateField/m-p/116184#M750709 <HTML><HEAD></HEAD><BODY><P>My If statement is below. I've tried a few different thins that don't seem to work. It's not recognizing the criteria for 'US Entry Date' and is lumping these into the 'Other' category.</P><P></P><P></P><P>=IF(DWHUSEntryDt= '$(=$(vMaxRptDate))','US Entry Date',</P><P>IF(DWHAllocStCd='U' AND DWHAllocNum &lt;&gt;0,'Backed Out Allocation',</P><P>&nbsp;&nbsp;&nbsp; 'Other'))</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT greend21 2020-11-25T16:16:04Z IF(Datefield = Max(OtherDateField), ... https://community.qlik.com/t5/QlikView/IF-Datefield-Max-OtherDateField/m-p/116184#M750709 <HTML><HEAD></HEAD><BODY><P>My If statement is below. I've tried a few different thins that don't seem to work. It's not recognizing the criteria for 'US Entry Date' and is lumping these into the 'Other' category.</P><P></P><P></P><P>=IF(DWHUSEntryDt= '$(=$(vMaxRptDate))','US Entry Date',</P><P>IF(DWHAllocStCd='U' AND DWHAllocNum &lt;&gt;0,'Backed Out Allocation',</P><P>&nbsp;&nbsp;&nbsp; 'Other'))</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/IF-Datefield-Max-OtherDateField/m-p/116184#M750709 greend21 2020-11-25T16:16:04Z Re: IF(Datefield = Max(OtherDateField), ... https://community.qlik.com/t5/QlikView/IF-Datefield-Max-OtherDateField/m-p/116185#M750710 <HTML><HEAD></HEAD><BODY><P>Look here</P><P><A href="https://community.qlik.com/thread/319212">IF(Datefield = Max(OtherDateField), ...</A></P></BODY></HTML> Wed, 07 Nov 2018 15:53:45 GMT https://community.qlik.com/t5/QlikView/IF-Datefield-Max-OtherDateField/m-p/116185#M750710 sunny_talwar 2018-11-07T15:53:45Z