Master Calendar help!

[#1]

All,

I've used this master calendar for ~20 of my clients, but I cannot seem to figure out why this keeps erroring out. Let me know if you have any suggestions.

[maxgro]

Empty APData table?

[#3]

No its pulling 267,000 lines from the APData table which is pulling from a qvd.

[#4]

The only difference in the data with this client is there is only one year of data -- 2015, where we usually have 2-3 years, could this be the issue?

[sunny_talwar]

I have run into this issue few times. I would check if QlikView understands the DateCheck as date. It might be read as date or DateCheck may be completely blank.

[sunny_talwar]

Can you try reloading the qvd without mastercalendar script and create a straight table with this:

Dimension: DateCheck

Expression: Num(DateCheck)

Just to make sure that date is read as a date field by QlikView.

[#7]

[sunny_talwar]

Can you try the variable like this:

LET vMaxDate = Peek('MaxDate');

LET vMinDate = Peek('MinDate');

[#9]

Same error as before..

[rwunderlich]

It looks like both your peek() statements are returning null.  Exit the script after creating the MinMax table and see what's in the table.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com