Help with Shipment counts by Product and Month, Months are ignored when 0 shipments

[dmackint]

Hello,

I am trying to achieve an overall ship count by month for products using Shipments data source

The issue i am facing, is when we do not ship a product for a specific month, i cannot seem to get Qlik to register that month as 0 shipments. Instead that Month and product combination does not show up on our flat table.

For example, Product1 was shipped 12 times in November, and 15 times in January

I would like to see a table that shows:

Product 1 - November- 12 shipments
Product 1 - December- 0 shipments
Product 1 - January- 15 shipments

Instead i am seeing:

Product 1 - November- 12 shipments
Product 1 - January- 15 shipments

Any advice would be greatly appreciated, Thank you very much in advance

[zzyjordan]

Hi,
In your case, you either need to create a master calendar as below link shows or join your data to a calendar table which contains all the month (month will be the key to join to)

https://community.qlik.com/t5/QlikView-Scripting/Creating-A-Master-Calendar/td-p/341286

ZZ