Qlik Community

Qlik Sense App Development

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

QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
New Contributor II

Display Month Dimension Chart (even when no data exists)

Hi All

There are various posts relating to my question but thus far haven't been able to find a solution!

I need to create a line/bar chart which has one measure and one dimension (the month)
I always want the chart to show a static 12 months (Jan-Dec) even when there is no actual data for a given month.  

My data is organised as follows

Item #1928Jan2019
Item #2562Jan2019
Item #322Feb2019
item #4881Feb2019
Item #5900Feb2019
Item #6101Mar2019
Item #7402Mar2019


This is how is shows currently but I want to show full 12 months (even with no data)


Any help much appreciated


1 Reply

Re: Display Month Dimension Chart (even when no data exists)


You can't show what is not existing.

You have to create dummy values for each month to have an existing value to show.

For example



month(makedate(2019,rowno())) as Month,

'2019' as Year,

0 as Value

autogenerate (12);     // 12 lines for 12 months

left join distinct 

Item     // all Items in your data if you want to select

from your_table;

concatenate (your_table)      // add them to your existing datas

load * resident Dummy_datas;

drop table Dummy_datas;