topic Re: IF(Datefield = Max(OtherDateField), ... in QlikView

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

greend21 — Wed, 25 Nov 2020 16:16:04 GMT

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

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

sunny_talwar — Wed, 07 Nov 2018 15:53:26 GMT

How do you define vMaxRptDate?

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

greend21 — Wed, 07 Nov 2018 15:55:20 GMT

Max(ReportDate)

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

sunny_talwar — Wed, 07 Nov 2018 16:01:38 GMT

Try this

=If(DWHUSEntryDt = Max(TOTAL ReportDate), 'US Entry Date', If(DWHAllocStCd='U' and DWHAllocNum <> 0, 'Backed Out Allocation', 'Other'))

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

greend21 — Wed, 07 Nov 2018 16:27:12 GMT

This still didn't work and as of right now I only have one ReportDate. I realized what I want to do won't work though because I'm going to need to flag the information in the load script. I don't want anything that's not =Max(ReportDate) to be bucketed as other in the future.