Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 