Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Autogenerate calendar and data

I have an auto generated master calendar:

LOAD

date(date#(20100509,'YYYYMMDD') + (recno() * 7),'MM/DD/YY') as "start_of_week"

AUTOGENERATE (MakeDate(2011, 12, 31) - MakeDate(2010,5, 9) + 1)/7;



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?

Labels (1)
0 Replies