topic default date > field date in QlikView

default date > field date

bsbernabe — Sat, 16 Nov 2024 00:11:06 GMT

Hello There,

how to use this kind of function in QlikView

IF(06/30/2020 > FieldDate, "yes" the also

IF field A- (MONTHS BETWEEN 06/30/2020 - FieldDate) == REM, "CURRENT"
ELSE "FUL"

Thanks

Bing

rubenmarin — Fri, 07 Aug 2020 17:11:33 GMT

Hi, the question is somewhat cryptical, so the answer it's also some to get as an idea:

If(Date('06/30/2020')>FieldDate ,'yes' ,If(fieldA-((Year(FieldDate)*12+Month(FieldDate))-(2020*12+6))=REM ,'CURRENT' ,'FUL' ))

bsbernabe — Sun, 16 Aug 2020 03:07:42 GMT

Hello There,

Thank you so much for the solution You've shared.

Best Regards.