Blank bars in bar chart for missing data

[aditic09]

if i select a particular filter, then will i be able to see blank bars for suppose 202601 202602 202603 in bar chart even if it does have data for that particular year month. 

In the screenshot provided, there is data till 202512, but i want to see 202601, 202602, 202603 blank bars as data is not there

[marcus_sommer]

The simplest way is to populate the missing information within the fact-table.

[priscilarubim · Accepted solution]

By default, Qlik Sense only displays dimension values that exist in your data. Maybe you could build a Master Calendar in your load script containing every YearMonth within the desired range, and then link it to your fact table. That way, 202601, 202602, 202603 will exist as dimension values even when there are no records in the fact table, and Qlik will render empty bars for them.

[ysalvi43]

Hello @aditic09  ,

you can create the master calender in the backend and extract the Year-month from the master calender. and in front end you can use alt(sum(sales),0). after using this you can see similar to the screenshot 

let  me know if any clarification is required. 

Thanks