Missing Dates

[smilingjohn]

Hi All,

I have a date and i am trying to convert it to weekends and to do so I have used matsr calendar . 

Please find the attachment . But after loading I dont see it is properly working as there are weekends missing . 

and also the weekend date should be generated till today . 

How do I achive this ? Please find the attachment of the Qvw file for refrence . 

[Miguel_Angel_Baeyens · Accepted solution]

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.

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)

See here for further reference:

https://community.qlik.com/t5/New-to-QlikView/Gap-in-time-series-despite-of-Master-Calendar/m-p/1727...