topic Re: logic help in QlikView

logic help

abhaysingh — Wed, 16 Dec 2015 11:22:48 GMT

hi,

i have one logic

if(isnull(DateSubmitted),DateDueGracePeriod,DateSubmitted ) as DateNew,

DateDueGracePeriod= these include the dates till year 2020, but i want to restrict it at backend .

i want in DateDueGracePeriod always there would be dates less than today, shud not exceed 16 dec 2015..

how i can do this?

swuehl — Wed, 16 Dec 2015 11:25:10 GMT

if(isnull(DateSubmitted),Date(RangeMin(DateDueGracePeriod,Today())),DateSubmitted ) as DateNew,

gsbeaton — Wed, 16 Dec 2015 11:29:23 GMT

When you say restrict in the backend, I presume you mean in the Load Script?

In the case I think you want something like

LOAD *

FROM [yourSource.QVD]

WHERE DateDueGracePeriod <= Today;

There are other ways you could go about this, but hopefully this will get you started.

sunny_talwar — Wed, 16 Dec 2015 11:29:41 GMT

May be something like this:

LOAD YourFields,

If(IsNull(DateSubmitted), DateDueGracePeriod, DateSubmitted) as DateNew,

FROM Source

Where not IsNull(DateSubmitted) or Num(DateDueGracePeriod) <= Num(Today());