Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikdash2000
Contributor II
Contributor II

Create Missing "0" Value

My dimension is "Month" and I have a measure that looks like this:

Sum(Sales)

The resulting table looks like this:

MonthSum(Sales)
Jan3
March1
April1
June5

 

You can see that I sold three cars in January, one car in March and April, and five cars in June. However, I did not sell any cars in February or May, and that's why they don't appear in the table above.

When I plot this as a bar chart there are missing values for February and May. Are there any way to force values of zero for these two months, so the months will display on my bar chart?

Labels (3)
1 Reply
Digvijay_Singh

Do you have a master calendar in your data model, you will need all the months available in your dimension through master calendar to achieve the required behavior.