I have a Qlikview document that was working OK, it has several tables with common fields including calendar date, month date and year date.
I added Week day name and week commencing fields to the tables and now on of them does not show the correct results. I have a date hierarchy for the dimension of my chart, but for one of the options no data is available at day of month level and year level shows '-' instead of the year.
I have added pictures of the chart and the table view for the document.
