topic IF Statements in QlikView

IF Statements

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

Hi,

I am trying to create a field on the load statement that returns Y if the Payment Due Dt is < ReportDate else returns N. This field can be named Overdue.

Is that possible?

Thanks,

Daniel

Re: IF Statements

MindaugasBacius — Fri, 20 Jan 2017 13:21:13 GMT

I suppose that both fields are in one table than in Script just insert one line like:

Load *

,If([Payment Due Dt] < ReportDate, 'Y', 'N') as Overdue

From YourTable;

Re: IF Statements

sunny_talwar — Fri, 20 Jan 2017 13:21:57 GMT

Do you have Payment Due Dt and ReportDate in the same table? If you do, then it is as simple as doing this

If([Payment Due Dt] < ReportDate, 'Y', 'N') as Overdue

If they are not in the same table, you will have to somehow bring them in the same table....

Re: IF Statements

danielnevitt — Fri, 20 Jan 2017 13:23:43 GMT

Thanks for your help