Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Showing results for 
Search instead for 
Did you mean: 

how to return count 0 for missing records in a line chart

I have a fact table and a date dimension table.  My fact table is incomplete by date.  That is, there are certain dates in my date dimension table where there is no corresponding record in my fact table.  I need to display a line chart of the count of records in my fact table, by date.  I would expect those dates that have no fact records to return count 0.  But, it doesn't.  Because of this, the given date doesn't appear as a value in the time axis of the chart.  How can I resolve this?  That is, I need a count of 0 to return for those dates where no fact record is present.

1 Reply

This is a classic reason to create a master calendar.
You could also just create a field based on your date field that finds the min and max values and fills in the gaps.
Take a look at these articles: