topic Show all months even if no data in QlikView https://community.qlik.com/t5/QlikView/Show-all-months-even-if-no-data/m-p/194231#M55212 <HTML><HEAD></HEAD><BODY><P>I have created a pivot table which has the months across the top. If I select some data e.g. actuals - the months which have no data disappear.</P><P>Is it possible keep the headings so that the table alwyas shows the same number of columns. The formula currently reasds Sum(Value). If I chaneg this to have 12 formul;as for 1 mont this might work, but not sure of most efficinet way of doing this.</P><P>i.e. I always want to show all 12 month names irrespective of if there is any data.</P></BODY></HTML> Thu, 09 Sep 2010 06:56:19 GMT alan_grn 2010-09-09T06:56:19Z Show all months even if no data https://community.qlik.com/t5/QlikView/Show-all-months-even-if-no-data/m-p/194231#M55212 <HTML><HEAD></HEAD><BODY><P>I have created a pivot table which has the months across the top. If I select some data e.g. actuals - the months which have no data disappear.</P><P>Is it possible keep the headings so that the table alwyas shows the same number of columns. The formula currently reasds Sum(Value). If I chaneg this to have 12 formul;as for 1 mont this might work, but not sure of most efficinet way of doing this.</P><P>i.e. I always want to show all 12 month names irrespective of if there is any data.</P></BODY></HTML> Thu, 09 Sep 2010 06:56:19 GMT https://community.qlik.com/t5/QlikView/Show-all-months-even-if-no-data/m-p/194231#M55212 alan_grn 2010-09-09T06:56:19Z Show all months even if no data https://community.qlik.com/t5/QlikView/Show-all-months-even-if-no-data/m-p/194232#M55213 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Goto 'Dimension' tab, Check "Show all values"........then Move to "Presentation" tab, UNcheck "Suppress Zero -Values".</P><P>Hope this would give your desired output.</P><P></P><P>Regards,</P><P>tresesco</P></BODY></HTML> Thu, 09 Sep 2010 07:18:51 GMT https://community.qlik.com/t5/QlikView/Show-all-months-even-if-no-data/m-p/194232#M55213 tresB 2010-09-09T07:18:51Z Show all months even if no data https://community.qlik.com/t5/QlikView/Show-all-months-even-if-no-data/m-p/194233#M55214 <HTML><HEAD></HEAD><BODY><P>Thanks that has worked.</P></BODY></HTML> Thu, 09 Sep 2010 08:45:56 GMT https://community.qlik.com/t5/QlikView/Show-all-months-even-if-no-data/m-p/194233#M55214 alan_grn 2010-09-09T08:45:56Z