Discussion Board for collaboration related to QlikView App Development.
can u please help me with the below requirement
I have a table i like below
I want to calculate new field start date -- for that i have used function 'FirstWorkDate' like below
FirstWorkDate(Date,days) As StartDate
data looks like below
But My Requirement here is -- it should not take startdate into consideration while doing calculation (date - days) with firstworkdate
expected output :
Thanks In advance
Please find the script below and output attached. Hope it helps you..
data:load * inline [Date,days
newdata:load *,FirstWorkDate(newdate,days,-1)as firstworkdate;load *,num(date(date#(Date,'YYYY/MM/DD'),'YYYY/MM/DD'))-1 as newdateResident data;drop table data;
View solution in original post