topic Re: Show completeYearMonth in QlikView https://community.qlik.com/t5/QlikView/Show-completeYearMonth/m-p/1149017#M375723 <HTML><HEAD></HEAD><BODY><P>Read this</P><P></P><P><A href="https://community.qlik.com/qlik-blogpost/2802">The Master Calendar</A></P><P></P><P>One of the uses of Master Calendar is to&nbsp; fill in the Gaps between dates in your FACT</P></BODY></HTML> Tue, 26 Jul 2016 19:07:14 GMT vinieme12 2016-07-26T19:07:14Z Show completeYearMonth https://community.qlik.com/t5/QlikView/Show-completeYearMonth/m-p/1149016#M375722 <HTML><HEAD></HEAD><BODY><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/132579_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P><P>I created a Pivot Chart, as the picture showed, the 2009-05, 2009-07 etc are missing because there is no data with that dimension value. However, for report purpose, I want those months also displayed as a row, and the value for other columns display as 0 or -. Is there a way I can make it happen?</P></BODY></HTML> Tue, 26 Jul 2016 18:28:01 GMT https://community.qlik.com/t5/QlikView/Show-completeYearMonth/m-p/1149016#M375722 2016-07-26T18:28:01Z Re: Show completeYearMonth https://community.qlik.com/t5/QlikView/Show-completeYearMonth/m-p/1149017#M375723 <HTML><HEAD></HEAD><BODY><P>Read this</P><P></P><P><A href="https://community.qlik.com/qlik-blogpost/2802">The Master Calendar</A></P><P></P><P>One of the uses of Master Calendar is to&nbsp; fill in the Gaps between dates in your FACT</P></BODY></HTML> Tue, 26 Jul 2016 19:07:14 GMT https://community.qlik.com/t5/QlikView/Show-completeYearMonth/m-p/1149017#M375723 vinieme12 2016-07-26T19:07:14Z Re: Show completeYearMonth https://community.qlik.com/t5/QlikView/Show-completeYearMonth/m-p/1149018#M375724 <HTML><HEAD></HEAD><BODY><P>Dimension Tab -&gt; Uncheck Supress Null Value </P><P>Presentation tab -&gt; uncheck supress 0 values</P><P></P><P>Try them.</P></BODY></HTML> Tue, 26 Jul 2016 19:07:53 GMT https://community.qlik.com/t5/QlikView/Show-completeYearMonth/m-p/1149018#M375724 vishsaggi 2016-07-26T19:07:53Z