Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
thnkgreen
Contributor

Adding days to an existing date and formatting

Hello my Qlik friends around the world.  I am trying to re-write an existing Excel formula to use in a Load statement in QlikView.  Here is the Excel formula:

=IF(F2="85DAYPEND",D2+85,

IF(F2="FINATMPT",D2+30, IF(F2="ATMPTPLUS",D2+30,

IF(F2="NEEDATPYPL",D2+30,

IF(OR(F2="ATTEMPT1",F2="NEEDATPT2"),D2+300,

IF(OR(F2="ATTEMPT2",F2="NEEDATPT3"),D2+270,

IF(OR(F2="ATTEMPT3",F2="NEEDATPT4"),D2+240,

IF(OR(F2="ATTEMPT4",F2="NEEDATPT5"),D2+210,

IF(OR(F2="ATTEMPT5",F2="NEEDATPT6"),D2+180,

IF(OR(F2="ATTEMPT6",F2="NEEDATPT7"),D2+150,

IF(OR(F2="ATTEMPT7",F2="NEEDATPT8"),D2+120,

IF(OR(F2="ATTEMPT8",F2="NEEDATPT9"),D2+90,

IF(F2="ATTEMPT9",D2+60,"")))))))))))))

I am having trouble with the "D2" portion of the formula.  The "D2" value is a cell with a date value in it, formatted as yyyy-mm-dd.  I need to add, for example 85 days to the existing date if the value in cell F2 is equal to "85DAYPEND".  I would truly appreciate some help with this formula.  Thank you everyone

Community Browser