error when reloading

[#1]

I am getting a script line error when reloading my qvd file. the error message is in the image attached

[simenkg]

It would help me if you paste scripting as text instead of images so I can just edit it.

[TempCalendar]:
load

     Date('$(vMinDate)'+RowNo() - 1)      as TempDate
AutoGenerate

     ('$(vMaxDate)'-'$(vMinDate)'+1)
;

[#3]

Script line error:

[TempCalendar]:

Load

  Date(''+RowNo() - 1) as TempDate

  AutoGenerate

  (''-''+1)

[simenkg]

Can you paste the lines where vMinDate and vMaxDate are defined?

[#5]

Is this where its defined?

[MinMax]:

Load

  Min(ServiceDate) as MinDate

  ,Max(ServiceDate) as MaxDate

Resident

  [CensusFact];

  Let vMinDate = Num(Peek('MinDate',0,'MinMax'));

  Let vMaxDate = Num(Peek('MaxDate',0,'MinMax'));

  // -- Variable used in UI for variance calculations -- //

  Let vCurrentMonth = Date(MonthStart(Date(Peek('MaxDate', 0, 'MinMax'))), 'MMM YYYY');

  Let vMaxWeek = If(MonthName(WeekEnd('$(vMaxDate)')) = MonthName(WeekStart('$(vMaxDate)')),

  Date(WeekStart(Peek('MaxDate', 0, 'MinMax'))), Date(WeekStart(Peek('MaxDate', 0, 'MinMax')) - 7));

[simenkg]

Yes, however I cannot see the error immediately. Could you copy all the text on that tab and save it as a text document and attach it so I can test it. 

[#7]

Attached is the text file. Thank you so much also if you could tell me how you fixed it and what the problem was, I would appreciate that. THANKS AGAIN

[simenkg]

Thanks, however the script runs fine for me.

Lets try one more thing first.

Insert "Exit script;" at this location.

[MinMax]:

Load

  Min(ServiceDate) as MinDate

  ,Max(ServiceDate) as MaxDate

Resident

  [CensusFact];

Exit script;

Then run the script and open the table viewer by pressing the button in the attached image. Then right-click the MinMax-table and press "Preview".

Could you take a screenshot of the resulting table?

[#9]

This ran but the qvw is now empty can I send you the qvd file?

[simenkg]

Is there no table named MinMax in the TableViewer?

[#11]

when I insert exit script, yes but then only the minmax and census fact tables are showing. its missing 3 other tables