Qlik Community

Qlik Sense App Development

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

Announcements
See why Qlik is recognized as a Leader for the 10th year in a row – and discover how Qlik can help put your business in the lead. Get Report
Highlighted
dmackint
New Contributor

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

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

Labels (4)
1 Reply
Highlighted
zzyjordan
Contributor II

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

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