topic Re: Handling null values in bar chart with two dimensions in QlikView https://community.qlik.com/t5/QlikView/Handling-null-values-in-bar-chart-with-two-dimensions/m-p/100536#M508987 <HTML><HEAD></HEAD><BODY><P>Any help on this?</P></BODY></HTML> Mon, 24 Sep 2018 16:06:16 GMT apoorvasd 2018-09-24T16:06:16Z Handling null values in bar chart with two dimensions https://community.qlik.com/t5/QlikView/Handling-null-values-in-bar-chart-with-two-dimensions/m-p/100535#M508986 <HTML><HEAD></HEAD><BODY><P>Hello Everyone,</P><P></P><P>I have a bar chart with two dimensions and one expression. One dimension is "Month" and the other one say, "Type". I want the x-axis to display all the month values, though it might have null values. When I check the option "Suppress When Value is Null" for dimension, "Type", all months except which has data disappears. But when I uncheck this option, I see null to appear in the legend as shown in pictures below. I want to display all month values in x-axis and also don't want the null symbol to appear in the legend. How do I do this?</P><P></P><P>"Suppress When Value is Null" is unchecked</P><P><IMG alt="graph1.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/214264_graph1.PNG" style="height: 154px; width: 620px;" /></P><P></P><P>"Suppress When Value is Null" is checked</P><P><IMG alt="graph2.PNG" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/214274_graph2.PNG" style="height: 153px; width: 620px;" /></P><P></P><P>Any help?</P><P></P><P>Thank you.</P></BODY></HTML> Mon, 24 Sep 2018 10:01:44 GMT https://community.qlik.com/t5/QlikView/Handling-null-values-in-bar-chart-with-two-dimensions/m-p/100535#M508986 apoorvasd 2018-09-24T10:01:44Z Re: Handling null values in bar chart with two dimensions https://community.qlik.com/t5/QlikView/Handling-null-values-in-bar-chart-with-two-dimensions/m-p/100536#M508987 <HTML><HEAD></HEAD><BODY><P>Any help on this?</P></BODY></HTML> Mon, 24 Sep 2018 16:06:16 GMT https://community.qlik.com/t5/QlikView/Handling-null-values-in-bar-chart-with-two-dimensions/m-p/100536#M508987 apoorvasd 2018-09-24T16:06:16Z