topic Show all values for all months in QlikView https://community.qlik.com/t5/QlikView/Show-all-values-for-all-months/m-p/1259370#M397492 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>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.</P><P></P><P>Below is two screencaps of what the data looks like when I try to get this done...</P><P></P><P><IMG alt="1.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/145408_1.JPG" style="max-width: 620px; height: auto;" /></P><P>The above chart is my products and months as dimension, with a sum(1) as an expression. </P><P></P><P><IMG alt="2.JPG" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/145409_2.JPG" style="height: auto;" /></P><P>The above chart is same as above, but with sum(qty) as expressions for the years.</P><P></P><P>I want this table to populate March-December with zero values.</P><P>Is this possible?</P><P></P><P>Thanks,</P><P></P><P>Wynand</P></BODY></HTML> Thu, 01 Dec 2016 09:11:08 GMT wcilliers 2016-12-01T09:11:08Z Show all values for all months https://community.qlik.com/t5/QlikView/Show-all-values-for-all-months/m-p/1259370#M397492 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>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.</P><P></P><P>Below is two screencaps of what the data looks like when I try to get this done...</P><P></P><P><IMG alt="1.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/145408_1.JPG" style="max-width: 620px; height: auto;" /></P><P>The above chart is my products and months as dimension, with a sum(1) as an expression. </P><P></P><P><IMG alt="2.JPG" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/145409_2.JPG" style="height: auto;" /></P><P>The above chart is same as above, but with sum(qty) as expressions for the years.</P><P></P><P>I want this table to populate March-December with zero values.</P><P>Is this possible?</P><P></P><P>Thanks,</P><P></P><P>Wynand</P></BODY></HTML> Thu, 01 Dec 2016 09:11:08 GMT https://community.qlik.com/t5/QlikView/Show-all-values-for-all-months/m-p/1259370#M397492 wcilliers 2016-12-01T09:11:08Z Re: Show all values for all months https://community.qlik.com/t5/QlikView/Show-all-values-for-all-months/m-p/1259371#M397493 <HTML><HEAD></HEAD><BODY><P>Can you provide few lines of sample data?</P><P>Meantime you can check this.</P><P><A href="https://community.qlik.com/docs/DOC-3786">Generating Missing Data In QlikView</A></P></BODY></HTML> Thu, 01 Dec 2016 09:14:11 GMT https://community.qlik.com/t5/QlikView/Show-all-values-for-all-months/m-p/1259371#M397493 MK_QSL 2016-12-01T09:14:11Z Re: Show all values for all months https://community.qlik.com/t5/QlikView/Show-all-values-for-all-months/m-p/1259372#M397494 <HTML><HEAD></HEAD><BODY><P>Would you be able to share a sample to play around with?</P></BODY></HTML> Thu, 01 Dec 2016 09:14:24 GMT https://community.qlik.com/t5/QlikView/Show-all-values-for-all-months/m-p/1259372#M397494 sunny_talwar 2016-12-01T09:14:24Z