topic Re: display zero on axis in case of missing data in QlikView https://community.qlik.com/t5/QlikView/display-zero-on-axis-in-case-of-missing-data/m-p/1009228#M342566 <HTML><HEAD></HEAD><BODY><P>Or create a date data-island and use that for the dimension. This does not require messing with the fact table, but will not perform as well on really large data sets. See this link for more:</P><P></P><P><A href="https://community.qlik.com/thread/178122">Showing Missing Time Data on a chart axis</A></P><P></P><P>Check out the blog link in the above thread as well.</P></BODY></HTML> Thu, 27 Aug 2015 11:56:34 GMT jonathandienst 2015-08-27T11:56:34Z display zero on axis in case of missing data https://community.qlik.com/t5/QlikView/display-zero-on-axis-in-case-of-missing-data/m-p/1009226#M342564 <HTML><HEAD></HEAD><BODY><P>How to display zero on axis for the bar which has missing values in qlikview bar chart</P></BODY></HTML> Thu, 27 Aug 2015 11:26:30 GMT https://community.qlik.com/t5/QlikView/display-zero-on-axis-in-case-of-missing-data/m-p/1009226#M342564 2015-08-27T11:26:30Z Re: display zero on axis in case of missing data https://community.qlik.com/t5/QlikView/display-zero-on-axis-in-case-of-missing-data/m-p/1009227#M342565 <HTML><HEAD></HEAD><BODY><P>Insert zero-records into your facts table(s)?</P><P>QlikView won't calculate anything if data is non-existent and you cannot force it to do otherwise by selecting one or more checkboxes... </P></BODY></HTML> Thu, 27 Aug 2015 11:30:31 GMT https://community.qlik.com/t5/QlikView/display-zero-on-axis-in-case-of-missing-data/m-p/1009227#M342565 Peter_Cammaert 2015-08-27T11:30:31Z Re: display zero on axis in case of missing data https://community.qlik.com/t5/QlikView/display-zero-on-axis-in-case-of-missing-data/m-p/1009228#M342566 <HTML><HEAD></HEAD><BODY><P>Or create a date data-island and use that for the dimension. This does not require messing with the fact table, but will not perform as well on really large data sets. See this link for more:</P><P></P><P><A href="https://community.qlik.com/thread/178122">Showing Missing Time Data on a chart axis</A></P><P></P><P>Check out the blog link in the above thread as well.</P></BODY></HTML> Thu, 27 Aug 2015 11:56:34 GMT https://community.qlik.com/t5/QlikView/display-zero-on-axis-in-case-of-missing-data/m-p/1009228#M342566 jonathandienst 2015-08-27T11:56:34Z Re: display zero on axis in case of missing data https://community.qlik.com/t5/QlikView/display-zero-on-axis-in-case-of-missing-data/m-p/1009229#M342567 <HTML><HEAD></HEAD><BODY><P>go to chart properties, then presentation and check the Zero on Bars options</P></BODY></HTML> Thu, 27 Aug 2015 12:04:16 GMT https://community.qlik.com/t5/QlikView/display-zero-on-axis-in-case-of-missing-data/m-p/1009229#M342567 maleksafa 2015-08-27T12:04:16Z Re: display zero on axis in case of missing data https://community.qlik.com/t5/QlikView/display-zero-on-axis-in-case-of-missing-data/m-p/1009230#M342568 <HTML><HEAD></HEAD><BODY><P>I dont think that will help with missing values...</P></BODY></HTML> Thu, 27 Aug 2015 12:25:51 GMT https://community.qlik.com/t5/QlikView/display-zero-on-axis-in-case-of-missing-data/m-p/1009230#M342568 jonathandienst 2015-08-27T12:25:51Z Re: display zero on axis in case of missing data https://community.qlik.com/t5/QlikView/display-zero-on-axis-in-case-of-missing-data/m-p/1009231#M342569 <HTML><HEAD></HEAD><BODY><P>it will work only in case of line chart i have done, but in bar chart with multiple expression not working but works with one expression</P></BODY></HTML> Fri, 28 Aug 2015 05:58:54 GMT https://community.qlik.com/t5/QlikView/display-zero-on-axis-in-case-of-missing-data/m-p/1009231#M342569 2015-08-28T05:58:54Z