6 Replies Latest reply: Apr 15, 2015 4:20 AM by Thomas Rieck RSS

    How do I add dates with zero data to my bar chart?

      I am using QlikSense.

       

      I want to see gaps in my bar chart where there is no data for every day. My original data does not have these zero values - it only has rows where something happened on that day. I have tried checking 'Show null values' but this doesn't seem to make a difference.

       

      If it has any implication, I have created the date dimension using MakeDate(Year,Month,Day) because my original data had individual columns for day, month and year.