https://community.qlik.com/t5/QlikView/Missing-Dates/m-p/1728250#M723529 <P>Hi All,</P><P>I have a date and i am trying to convert it to weekends and to do so I have used matsr calendar .&nbsp;</P><P>Please find the attachment . But after loading I dont see it is properly working as there are weekends missing .&nbsp;</P><P>and also the <STRONG>weekend date should be generated till today .&nbsp;</STRONG></P><P>How do I achive this ? Please find the attachment of the Qvw file for refrence .&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="smilingjohn_0-1594878445544.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/37495iC01420522988E30B/image-size/medium?v=v2&amp;px=400" role="button" title="smilingjohn_0-1594878445544.png" alt="smilingjohn_0-1594878445544.png" /></span></P><P>&nbsp;</P> Wed, 25 Nov 2020 16:16:04 GMT smilingjohn 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/Missing-Dates/m-p/1728250#M723529 <P>Hi All,</P><P>I have a date and i am trying to convert it to weekends and to do so I have used matsr calendar .&nbsp;</P><P>Please find the attachment . But after loading I dont see it is properly working as there are weekends missing .&nbsp;</P><P>and also the <STRONG>weekend date should be generated till today .&nbsp;</STRONG></P><P>How do I achive this ? Please find the attachment of the Qvw file for refrence .&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="smilingjohn_0-1594878445544.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/37495iC01420522988E30B/image-size/medium?v=v2&amp;px=400" role="button" title="smilingjohn_0-1594878445544.png" alt="smilingjohn_0-1594878445544.png" /></span></P><P>&nbsp;</P> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Missing-Dates/m-p/1728250#M723529 smilingjohn 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/Missing-Dates/m-p/1728354#M723530 <P>The MasterCalendar table is built correctly and what you see is completely expected: while the master calendar has all the dates (field Date1), the table coming from the excel spreadsheet does not have each data, therefore some days are null.</P><P>Data that does not exist cannot be displayed (meaning, there is not a single line for a given date, such date won't be displayed)</P><P>See here for further reference:</P><P><A href="https://community.qlik.com/t5/New-to-QlikView/Gap-in-time-series-despite-of-Master-Calendar/m-p/1727621#M391140" target="_blank">https://community.qlik.com/t5/New-to-QlikView/Gap-in-time-series-despite-of-Master-Calendar/m-p/1727621#M391140</A></P> Thu, 16 Jul 2020 10:03:16 GMT https://community.qlik.com/t5/QlikView/Missing-Dates/m-p/1728354#M723530 Miguel_Angel_Baeyens 2020-07-16T10:03:16Z