topic Re: Pivot Table Data Load Incorrect in QlikView https://community.qlik.com/t5/QlikView/Pivot-Table-Data-Load-Incorrect/m-p/1025214#M932076 <HTML><HEAD></HEAD><BODY><P>You can either use a master calendar or fill in the missing dates in your load script.</P></BODY></HTML> Tue, 08 Mar 2016 19:05:27 GMT m_woolf 2016-03-08T19:05:27Z Pivot Table Data Load Incorrect https://community.qlik.com/t5/QlikView/Pivot-Table-Data-Load-Incorrect/m-p/1025213#M932075 <HTML><HEAD></HEAD><BODY><P>i am facing a challenge in pivot table, when i am trying to load the data from DB with filter conditions few dates are not getting picked and plotted in pivot as they are getting filtered, hence the dates are getting jumped in pivot table but i want all dates to be pivot table and corresponding dates should show zero in the fields below is the screenshot of current status in pivot table.</P><P></P><P></P><P><IMG __jive_id="117297" alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/117297_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-Data-Load-Incorrect/m-p/1025213#M932075 2020-11-25T16:16:04Z Re: Pivot Table Data Load Incorrect https://community.qlik.com/t5/QlikView/Pivot-Table-Data-Load-Incorrect/m-p/1025214#M932076 <HTML><HEAD></HEAD><BODY><P>You can either use a master calendar or fill in the missing dates in your load script.</P></BODY></HTML> Tue, 08 Mar 2016 19:05:27 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-Data-Load-Incorrect/m-p/1025214#M932076 m_woolf 2016-03-08T19:05:27Z Re: Pivot Table Data Load Incorrect https://community.qlik.com/t5/QlikView/Pivot-Table-Data-Load-Incorrect/m-p/1025215#M932077 <HTML><HEAD></HEAD><BODY><P>hi,</P><P>can you please share master calendar script please and let me know if any configurations has to be done in Qlikview front end.</P><P></P><P>thanks in advance.</P></BODY></HTML> Thu, 10 Mar 2016 06:34:35 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-Data-Load-Incorrect/m-p/1025215#M932077 2016-03-10T06:34:35Z Re: Pivot Table Data Load Incorrect https://community.qlik.com/t5/QlikView/Pivot-Table-Data-Load-Incorrect/m-p/1025216#M932078 <HTML><HEAD></HEAD><BODY><P>chk dis</P><P><A href="https://community.qlik.com/message/198507">Creating A Master Calendar</A></P></BODY></HTML> Thu, 10 Mar 2016 08:55:52 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-Data-Load-Incorrect/m-p/1025216#M932078 Chanty4u 2016-03-10T08:55:52Z Re: Pivot Table Data Load Incorrect https://community.qlik.com/t5/QlikView/Pivot-Table-Data-Load-Incorrect/m-p/1025217#M932079 <HTML><HEAD></HEAD><BODY><P>or dis</P><P><A href="https://community.qlik.com/qlik-blogpost/2802">The Master Calendar</A></P></BODY></HTML> Thu, 10 Mar 2016 08:56:23 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-Data-Load-Incorrect/m-p/1025217#M932079 Chanty4u 2016-03-10T08:56:23Z