topic How do I keep months from disappearing from a bar chart? in QlikView https://community.qlik.com/t5/QlikView/How-do-I-keep-months-from-disappearing-from-a-bar-chart/m-p/1239368#M866278 <HTML><HEAD></HEAD><BODY><P>I have a bar chart with months going from left to right. Showing "resource effort" by month.</P><P></P><P>When I filter on one project, the month of January disappears from the bar chart, because there are no resources assigned to that project for January. I would like to keep January in the chart, how do I do that?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT Anonymous 2020-11-25T16:16:04Z How do I keep months from disappearing from a bar chart? https://community.qlik.com/t5/QlikView/How-do-I-keep-months-from-disappearing-from-a-bar-chart/m-p/1239368#M866278 <HTML><HEAD></HEAD><BODY><P>I have a bar chart with months going from left to right. Showing "resource effort" by month.</P><P></P><P>When I filter on one project, the month of January disappears from the bar chart, because there are no resources assigned to that project for January. I would like to keep January in the chart, how do I do that?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-do-I-keep-months-from-disappearing-from-a-bar-chart/m-p/1239368#M866278 Anonymous 2020-11-25T16:16:04Z Re: How do I keep months from disappearing from a bar chart? https://community.qlik.com/t5/QlikView/How-do-I-keep-months-from-disappearing-from-a-bar-chart/m-p/1239369#M866280 <HTML><HEAD></HEAD><BODY><P>It usually means you've no data to represent for the Month of Jan.</P><P>You can show Jan Month but it will be a 0</P><P>Uncheck the Suppress Zero Values in Presentation Tab, it will show Jan but with no bar or line.</P><P><IMG alt="Spend.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/146215_Spend.png" style="height: 495px; width: 620px;" /></P></BODY></HTML> Fri, 09 Dec 2016 19:10:58 GMT https://community.qlik.com/t5/QlikView/How-do-I-keep-months-from-disappearing-from-a-bar-chart/m-p/1239369#M866280 MK9885 2016-12-09T19:10:58Z Re: How do I keep months from disappearing from a bar chart? https://community.qlik.com/t5/QlikView/How-do-I-keep-months-from-disappearing-from-a-bar-chart/m-p/1239370#M866281 <HTML><HEAD></HEAD><BODY><P>Is that box checked by default? Mine is unchecked already. I should add my underlying data in excel doesn't have January in the "calendar month" column when filter on that one project. Is that why Qlik isn't showing January when I filter on that project. None the less i'd like it to appear on the bar chart even if it has zero data in Qlik.</P></BODY></HTML> Fri, 09 Dec 2016 19:16:32 GMT https://community.qlik.com/t5/QlikView/How-do-I-keep-months-from-disappearing-from-a-bar-chart/m-p/1239370#M866281 Anonymous 2016-12-09T19:16:32Z Re: How do I keep months from disappearing from a bar chart? https://community.qlik.com/t5/QlikView/How-do-I-keep-months-from-disappearing-from-a-bar-chart/m-p/1239371#M866282 <HTML><HEAD></HEAD><BODY><P>Also in Dimension tab flag "Show All Values" and "Suppress ...."</P></BODY></HTML> Fri, 09 Dec 2016 19:17:32 GMT https://community.qlik.com/t5/QlikView/How-do-I-keep-months-from-disappearing-from-a-bar-chart/m-p/1239371#M866282 maxgro 2016-12-09T19:17:32Z Re: How do I keep months from disappearing from a bar chart? https://community.qlik.com/t5/QlikView/How-do-I-keep-months-from-disappearing-from-a-bar-chart/m-p/1239372#M866284 <HTML><HEAD></HEAD><BODY><P>Yes it is by default and if you do not have Month January in data/calendar then I don't think you'll see Jan.</P></BODY></HTML> Fri, 09 Dec 2016 19:21:01 GMT https://community.qlik.com/t5/QlikView/How-do-I-keep-months-from-disappearing-from-a-bar-chart/m-p/1239372#M866284 MK9885 2016-12-09T19:21:01Z Re: How do I keep months from disappearing from a bar chart? https://community.qlik.com/t5/QlikView/How-do-I-keep-months-from-disappearing-from-a-bar-chart/m-p/1239373#M866285 <HTML><HEAD></HEAD><BODY><P>Ok, but remember, January appears when everything is unfiltered, because some projects have January. If i look at my excel spreadsheet unfiltered I see January. So continuing in excel, if I filter on project XYZ, January disappears in excel. </P><P></P><P>There is no way to keep january from disappearing in qlikview if I filter on XYZ? Because thats how it behaves in my excel file?</P></BODY></HTML> Fri, 09 Dec 2016 19:24:11 GMT https://community.qlik.com/t5/QlikView/How-do-I-keep-months-from-disappearing-from-a-bar-chart/m-p/1239373#M866285 Anonymous 2016-12-09T19:24:11Z Re: How do I keep months from disappearing from a bar chart? https://community.qlik.com/t5/QlikView/How-do-I-keep-months-from-disappearing-from-a-bar-chart/m-p/1239374#M866286 <HTML><HEAD></HEAD><BODY><P>this worked. thank you. </P></BODY></HTML> Fri, 09 Dec 2016 19:28:31 GMT https://community.qlik.com/t5/QlikView/How-do-I-keep-months-from-disappearing-from-a-bar-chart/m-p/1239374#M866286 Anonymous 2016-12-09T19:28:31Z