Error In Calander

[Brownie]

Hey can someone help me figure this error out. I cant seem to pick the field 

[MendyS]

Hi @Brownie 

in the calendar table, you make a load from autogenerate function, 

in line 54 you wrap with the date function the field MonthStartDate but you don't have this field in the table.

[vinieme12]

refer this article

https://qlikviewcookbook.com/2015/05/better-calendar-scripts/

[Mark_Little]

Like @MendyS said,

You would need to to use the Peek function to get the Values from MonthStartDate and MonthEndDate into variable and then reference these in lines 54 and 56

[Brownie · Accepted solution]

So i figured out the mistake. i was not using resident load in my iteration loop in order to call the field from the final table. anyways thankyou 

[MendyS]

@Brownie 

please, can you close the issue? 
thanks

[Brownie]

I have quantity of an entire month and i need to get daily quantity or quantity of each month from it. i think Quantity / Months but how to do that in load script effectively