topic Re: Nested IF formula involving greater than a fixed date in QlikView

Nested IF formula involving greater than a fixed date

Wed, 25 Nov 2020 16:16:04 GMT

Hi all

I am trying to write an expression in Edit Script and facing issues with it. This expression is as follows -

if([POLICYSTATUS]='Inf' and [DOC]>>31/01/2014,'NB',IF([POLICYSTATUS]='Inf' and not [DOC]>>31/01/2014,'RB','Lapsed')) as [NB/RB]

I think I am making some mistakes either in writing IF formula or date expression is wrong.

Can anyone please help me in this regard.

Thanks!

Abhik

sunny_talwar — Fri, 26 Aug 2016 09:14:11 GMT

Try this:

If([POLICYSTATUS] = 'Inf' and [DOC] > MakeDate(2014, 1, 31), 'NB',

If([POLICYSTATUS] = 'Inf' and [DOC] <= MakeDate(2014, 1, 31), 'RB', 'Lapsed')) as [NB/RB]

Fri, 26 Aug 2016 10:21:36 GMT

Great!! Thanks Sunny, it worked smoothly!!