Show all values for all months

[wcilliers]

Hi All,

I am trying to generate a table where I calculate product quantities by month for 2014, 2015 and 2016. I want to display all months Jan - Dec for every product, even when nothing was sold. However, I am struggling to accomplish this.

Below is two screencaps of what the data looks like when I try to get this done...

The above chart is my products and months as dimension, with a sum(1) as an expression.

The above chart is same as above, but with sum(qty) as expressions for the years.

I want this table to populate March-December with zero values.

Is this possible?

Thanks,

Wynand

[MK_QSL · Accepted solution]

Can you provide few lines of sample data?

Meantime you can check this.

Generating Missing Data In QlikView

[sunny_talwar]

Would you be able to share a sample to play around with?