topic Re: Master Calendar help! in QlikView https://community.qlik.com/t5/QlikView/Master-Calendar-help/m-p/1086245#M361669 <HTML><HEAD></HEAD><BODY><P>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? </P></BODY></HTML> Tue, 09 Feb 2016 23:00:12 GMT 2016-02-09T23:00:12Z Master Calendar help! https://community.qlik.com/t5/QlikView/Master-Calendar-help/m-p/1086242#M361666 <HTML><HEAD></HEAD><BODY><P>All, </P><P></P><P>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. </P><P></P><P><IMG alt="errorc.png" class="jive-image image-1" height="225" src="https://community.qlik.com/legacyfs/online/114082_errorc.png" style="height: 224.508px; width: 485px;" width="485" /></P><P><IMG alt="errorc2.png" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/114089_errorc2.png" style="height: auto;" /></P></BODY></HTML> Tue, 09 Feb 2016 22:32:30 GMT https://community.qlik.com/t5/QlikView/Master-Calendar-help/m-p/1086242#M361666 2016-02-09T22:32:30Z Re: Master Calendar help! https://community.qlik.com/t5/QlikView/Master-Calendar-help/m-p/1086243#M361667 <HTML><HEAD></HEAD><BODY><P>Empty APData table?</P></BODY></HTML> Tue, 09 Feb 2016 22:53:59 GMT https://community.qlik.com/t5/QlikView/Master-Calendar-help/m-p/1086243#M361667 maxgro 2016-02-09T22:53:59Z Re: Master Calendar help! https://community.qlik.com/t5/QlikView/Master-Calendar-help/m-p/1086244#M361668 <HTML><HEAD></HEAD><BODY><P>No its pulling 267,000 lines from the APData table which is pulling from a qvd.</P></BODY></HTML> Tue, 09 Feb 2016 22:58:56 GMT https://community.qlik.com/t5/QlikView/Master-Calendar-help/m-p/1086244#M361668 2016-02-09T22:58:56Z Re: Master Calendar help! https://community.qlik.com/t5/QlikView/Master-Calendar-help/m-p/1086245#M361669 <HTML><HEAD></HEAD><BODY><P>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? </P></BODY></HTML> Tue, 09 Feb 2016 23:00:12 GMT https://community.qlik.com/t5/QlikView/Master-Calendar-help/m-p/1086245#M361669 2016-02-09T23:00:12Z Re: Master Calendar help! https://community.qlik.com/t5/QlikView/Master-Calendar-help/m-p/1086246#M361670 <HTML><HEAD></HEAD><BODY><P>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.</P></BODY></HTML> Tue, 09 Feb 2016 23:01:02 GMT https://community.qlik.com/t5/QlikView/Master-Calendar-help/m-p/1086246#M361670 sunny_talwar 2016-02-09T23:01:02Z Re: Master Calendar help! https://community.qlik.com/t5/QlikView/Master-Calendar-help/m-p/1086247#M361671 <HTML><HEAD></HEAD><BODY><P>Can you try reloading the qvd without mastercalendar script and create a straight table with this:</P><P></P><P>Dimension: DateCheck</P><P>Expression: Num(DateCheck)</P><P></P><P>Just to make sure that date is read as a date field by QlikView.</P></BODY></HTML> Tue, 09 Feb 2016 23:07:43 GMT https://community.qlik.com/t5/QlikView/Master-Calendar-help/m-p/1086247#M361671 sunny_talwar 2016-02-09T23:07:43Z Re: Master Calendar help! https://community.qlik.com/t5/QlikView/Master-Calendar-help/m-p/1086248#M361672 <HTML><HEAD></HEAD><BODY><P><IMG alt="table.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/114090_table.png" style="height: auto;" /></P></BODY></HTML> Tue, 09 Feb 2016 23:19:25 GMT https://community.qlik.com/t5/QlikView/Master-Calendar-help/m-p/1086248#M361672 2016-02-09T23:19:25Z Re: Master Calendar help! https://community.qlik.com/t5/QlikView/Master-Calendar-help/m-p/1086249#M361673 <HTML><HEAD></HEAD><BODY><P>Can you try the variable like this:</P><P></P><P><STRONG>LET vMaxDate = Peek('MaxDate');</STRONG></P><P><SPAN style="font-size: 13.3333px;"><STRONG>LET vMinDate = Peek('MinDate');</STRONG></SPAN></P></BODY></HTML> Tue, 09 Feb 2016 23:26:37 GMT https://community.qlik.com/t5/QlikView/Master-Calendar-help/m-p/1086249#M361673 sunny_talwar 2016-02-09T23:26:37Z Re: Master Calendar help! https://community.qlik.com/t5/QlikView/Master-Calendar-help/m-p/1086250#M361674 <HTML><HEAD></HEAD><BODY><P>Same error as before.. </P><P></P><P></P><P><IMG alt="error5.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/114091_error5.png" style="height: auto;" /></P></BODY></HTML> Tue, 09 Feb 2016 23:31:45 GMT https://community.qlik.com/t5/QlikView/Master-Calendar-help/m-p/1086250#M361674 2016-02-09T23:31:45Z Re: Master Calendar help! https://community.qlik.com/t5/QlikView/Master-Calendar-help/m-p/1086251#M361675 <HTML><HEAD></HEAD><BODY><P>It looks like both your peek() statements are returning null.&nbsp; Exit the script after creating the MinMax table and see what's in the table.</P><P></P><P>-Rob</P><P><A class="jive-link-external-small" href="http://masterssummit.com" rel="nofollow">http://masterssummit.com</A></P><P><A class="jive-link-external-small" href="http://qlikviewcookbook.com" rel="nofollow">http://qlikviewcookbook.com</A></P></BODY></HTML> Tue, 09 Feb 2016 23:45:53 GMT https://community.qlik.com/t5/QlikView/Master-Calendar-help/m-p/1086251#M361675 rwunderlich 2016-02-09T23:45:53Z Re: Master Calendar help! https://community.qlik.com/t5/QlikView/Master-Calendar-help/m-p/1086252#M361676 <HTML><HEAD></HEAD><BODY><P><IMG alt="minmax.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/114098_minmax.png" style="height: 382px; width: 620px;" /></P></BODY></HTML> Tue, 09 Feb 2016 23:56:17 GMT https://community.qlik.com/t5/QlikView/Master-Calendar-help/m-p/1086252#M361676 2016-02-09T23:56:17Z Re: Master Calendar help! https://community.qlik.com/t5/QlikView/Master-Calendar-help/m-p/1086253#M361677 <HTML><HEAD></HEAD><BODY><P>Ahh thanks for all your help, nothing was wrong with the script, I just needed to promote the tab for the AUTOGENERATE to work. </P></BODY></HTML> Wed, 10 Feb 2016 01:13:27 GMT https://community.qlik.com/t5/QlikView/Master-Calendar-help/m-p/1086253#M361677 2016-02-10T01:13:27Z Re: Master Calendar help! https://community.qlik.com/t5/QlikView/Master-Calendar-help/m-p/1086254#M361678 <HTML><HEAD></HEAD><BODY><P>I looks like you have a "QUALIFY *" statement on the previous tab -- without an "UNQUALIFY *". </P><P></P><P>-Rob</P></BODY></HTML> Wed, 10 Feb 2016 23:38:07 GMT https://community.qlik.com/t5/QlikView/Master-Calendar-help/m-p/1086254#M361678 rwunderlich 2016-02-10T23:38:07Z Re: Master Calendar help! https://community.qlik.com/t5/QlikView/Master-Calendar-help/m-p/1086255#M361679 <HTML><HEAD></HEAD><BODY><P>Yep, that was it!</P></BODY></HTML> Wed, 10 Feb 2016 23:41:21 GMT https://community.qlik.com/t5/QlikView/Master-Calendar-help/m-p/1086255#M361679 2016-02-10T23:41:21Z