topic Re: How do you make bars show up even for null values? in QlikView https://community.qlik.com/t5/QlikView/How-do-you-make-bars-show-up-even-for-null-values/m-p/602501#M222706 <HTML><HEAD></HEAD><BODY><P>try using expression like: sum({&lt;set&gt;}sales) - sum({&lt;set&gt;}0)</P></BODY></HTML> Thu, 20 Mar 2014 16:49:20 GMT 2014-03-20T16:49:20Z How do you make bars show up even for null values? https://community.qlik.com/t5/QlikView/How-do-you-make-bars-show-up-even-for-null-values/m-p/602500#M222705 <HTML><HEAD></HEAD><BODY><P>So I have a bar chart with two expressions. I want both expressions to show up in the legend even if one of them is always null. Originally I was doing this: If(IsNull(Value), 0, Value) as the expression and it worked, but now it doesn't seem to be working.</P><P></P><P></P><P>I unchecked the Suppress Missing and Suppress Zero options.</P><P></P><P>Anyone have any ideas?</P></BODY></HTML> Thu, 20 Mar 2014 16:46:28 GMT https://community.qlik.com/t5/QlikView/How-do-you-make-bars-show-up-even-for-null-values/m-p/602500#M222705 2014-03-20T16:46:28Z Re: How do you make bars show up even for null values? https://community.qlik.com/t5/QlikView/How-do-you-make-bars-show-up-even-for-null-values/m-p/602501#M222706 <HTML><HEAD></HEAD><BODY><P>try using expression like: sum({&lt;set&gt;}sales) - sum({&lt;set&gt;}0)</P></BODY></HTML> Thu, 20 Mar 2014 16:49:20 GMT https://community.qlik.com/t5/QlikView/How-do-you-make-bars-show-up-even-for-null-values/m-p/602501#M222706 2014-03-20T16:49:20Z Re: How do you make bars show up even for null values? https://community.qlik.com/t5/QlikView/How-do-you-make-bars-show-up-even-for-null-values/m-p/602502#M222707 <HTML><HEAD></HEAD><BODY><P>If the dimension contains numeric values you can set the dimension axis to Continuous on the Axis tab.</P></BODY></HTML> Thu, 20 Mar 2014 16:50:14 GMT https://community.qlik.com/t5/QlikView/How-do-you-make-bars-show-up-even-for-null-values/m-p/602502#M222707 Gysbert_Wassenaar 2014-03-20T16:50:14Z Re: How do you make bars show up even for null values? https://community.qlik.com/t5/QlikView/How-do-you-make-bars-show-up-even-for-null-values/m-p/602503#M222708 <HTML><HEAD></HEAD><BODY><P>That worked! Thank you so much!</P></BODY></HTML> Thu, 20 Mar 2014 16:50:58 GMT https://community.qlik.com/t5/QlikView/How-do-you-make-bars-show-up-even-for-null-values/m-p/602503#M222708 2014-03-20T16:50:58Z