Bar Chart - Show months without data - Qlik Community

JulianaStr · ‎2022-10-26

Hi together,

I would like to create a bar chart:

X axis contains 12 bars for the last 12 months (Jan - Dez)

Y-axis contains number of new customer registrations incl. the registration date for instance.

Example:

No new customer was added in February, so there is no record with February registration date.

How do I get it solved that despite the empty data for February, February is displayed on the X-axis? Show zero values does not work.

Thanks for your help!

RafaelBarrios · ‎2022-10-26

My guess is that you are not using a master calendar, so as Feb doesn’t exists in your table , the chart doesn’t show it.

creating a master calendar from your min date to you max date will create all posible dates in a calendar table.

hope this helps.

best,

Help users find answers! Don't forget to mark a solution that worked for you & to smash the like button! 🙂

Bar Chart - Show months without data