topic Re: date in QlikView

date

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

Hi,

I want to do this in expression.

I have 2 columns Opening Date and closing Date, Lastupdatedate

I need to Add 1 year to an existing date column .. for ex: I So for a condition if closing date is null then take the date from opening Date and Add 1 year.

2 condition - If opening Date is null then take the date from Lastupdatedate and add 15 months.

any suggestions?

Re: date

swuehl — Fri, 24 Jun 2016 07:58:55 GMT

Maybe like

LOAD

OpeningDate,

If(IsNum(ClosingDate),ClosingDate, If(IsNum(OpeningDate),AddYears(OpeningDate,1),AddMonths(LastUpdateDate,15))) as ClosingDate,

LastUpdateDate,

....

FROM ..;

Re: date

raadwiptec — Fri, 24 Jun 2016 08:53:21 GMT

i found the solution ... i need it in expression basically.. it is if(IsNull(ClsoingDate), Date(AddYears(OpeningDate,1), ClosingDate))