Discussion board where members can get started with QlikView.
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.
=IF(DWHUSEntryDt= '$(=$(vMaxRptDate))','US Entry Date',
IF(DWHAllocStCd='U' AND DWHAllocNum <>0,'Backed Out Allocation',
IF(Datefield = Max(OtherDateField), ...