topic Autogenerate calendar and data in QlikView https://community.qlik.com/t5/QlikView/Autogenerate-calendar-and-data/m-p/188600#M51790 <HTML><HEAD></HEAD><BODY><P>I have an auto generated master calendar:</P><P></P><P>LOAD</P><P>date(date#(20100509,'YYYYMMDD') + (recno() * 7),'MM/DD/YY') as "start_of_week"</P><P>AUTOGENERATE (MakeDate(2011, 12, 31) - MakeDate(2010,5, 9) + 1)/7;</P><BR /><BR /> <P>What I'd also like to do is generate some data on each date. I have a field called target that I would like to generate a 0 value for on each of these dates and have it associated with that date. I'd also like to associate the value with a field called project for a constant value. So for each date for project = 'A' and project = 'B' have target = 0. How might I accomplish this?</P></BODY></HTML> Thu, 27 Jan 2011 15:04:33 GMT 2011-01-27T15:04:33Z Autogenerate calendar and data https://community.qlik.com/t5/QlikView/Autogenerate-calendar-and-data/m-p/188600#M51790 <HTML><HEAD></HEAD><BODY><P>I have an auto generated master calendar:</P><P></P><P>LOAD</P><P>date(date#(20100509,'YYYYMMDD') + (recno() * 7),'MM/DD/YY') as "start_of_week"</P><P>AUTOGENERATE (MakeDate(2011, 12, 31) - MakeDate(2010,5, 9) + 1)/7;</P><BR /><BR /> <P>What I'd also like to do is generate some data on each date. I have a field called target that I would like to generate a 0 value for on each of these dates and have it associated with that date. I'd also like to associate the value with a field called project for a constant value. So for each date for project = 'A' and project = 'B' have target = 0. How might I accomplish this?</P></BODY></HTML> Thu, 27 Jan 2011 15:04:33 GMT https://community.qlik.com/t5/QlikView/Autogenerate-calendar-and-data/m-p/188600#M51790 2011-01-27T15:04:33Z