Hi, I'm still on a large learning curve with Qlikview and I'm stuck. I have a date field which appears in an extract imusing in the format DD.MM.YYYY, I have worked out how to change but now I'm unable to use the new date format i created in a calculation.
Date
(Date#([Requested deliv.date],'DD.MM.YYYY'),'DD/MM/YYYY') as [Requested deliv.date2], I then want to say
if
([Requested deliv.date2]<=Today(),year(Yearname(today(),1,8))&'Q'&ceil(month(MonthName(today(), 5)) / 3),year(Yearname([Requested deliv.date2],1,8))&'Q'&ceil(month(MonthName([Requested deliv.date2], 5)) / 3))as Req_Delivery_Qtr,, When i run my script the Req_Delivery_Qtr is blank. I know that if i create the data ( in my extract) as DD/MM/YYYY the formula works.
I also know that the Requested deliv.Date2 is coming correctly.
Is this because of the way i am loading the data. Do I need to wait untill this table is fully loaded before making the calculation ? If so how do i do that ?
Thanks
