Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

IF(Datefield = Max(OtherDateField), ...

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',

    'Other'))

Tags (3)
1 Reply
Highlighted

Re: IF(Datefield = Max(OtherDateField), ...