Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
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.