topic Re: If statement in load in QlikView

If statement in load

Wed, 25 Nov 2020 16:16:04 GMT

Morning all

Can someone assist please.

I have the following statement in my load:

LOAD

IF ([EndOfMonth]<[Today],'Overdue',

IF ([EndOfMonth]<=[EndOfCurrentMonth], 'FALLING DUE BY END OF MONTH'))AS Status

Which is working fine.

However, I would like to adapt this to say that if it does not match either of these IF statement then

to put the text 'Overdue'

Thank you

sunny_talwar — Tue, 19 Apr 2016 08:07:40 GMT

May be this:

LOAD

If([EndOfMonth]<[Today],'Overdue',

If([EndOfMonth]<=[EndOfCurrentMonth], 'FALLING DUE BY END OF MONTH', 'OverDue')) as Status

kkkumar82 — Tue, 19 Apr 2016 08:09:31 GMT

I think you already have "overdue"

but anyhow

IF ([EndOfMonth]<[Today],'Overdue',

IF ([EndOfMonth]<=[EndOfCurrentMonth], 'FALLING DUE BY END OF MONTH'.'Overdue'))AS Status

sunny_talwar — Tue, 19 Apr 2016 08:13:37 GMT

Or may be this:

LOAD

If([EndOfMonth]<=[EndOfCurrentMonth], 'FALLING DUE BY END OF MONTH', 'OverDue') as Status

Tue, 19 Apr 2016 08:19:42 GMT

Thanks Sunny

For the different ways to achieve this.