topic Null values in data to show as - in QlikView https://community.qlik.com/t5/QlikView/Null-values-in-data-to-show-as/m-p/239006#M89738 <HTML><HEAD></HEAD><BODY><P>theres a checkbox in properties in the presentation tab tha says supress ZERO values you must uncheck that</P></BODY></HTML> Thu, 12 Aug 2010 15:54:06 GMT 2010-08-12T15:54:06Z Null values in data to show as - https://community.qlik.com/t5/QlikView/Null-values-in-data-to-show-as/m-p/239002#M89734 <HTML><HEAD></HEAD><BODY><P>I want null values to show up as -, not 0 when using set analysis and the data is null. I've tried all the Presentation options, but in this example, 0 is still shown when the Volume is Null. Simple qvw with inline data attached.</P><P><IMG alt="error loading image" class="jive-image error-loading-image" src="https://community.qlik.com/legacyfs/online/-2052_sourceID:2052" /></P></BODY></HTML> Fri, 30 Jul 2010 22:58:12 GMT https://community.qlik.com/t5/QlikView/Null-values-in-data-to-show-as/m-p/239002#M89734 pgdavis2 2010-07-30T22:58:12Z Null values in data to show as - https://community.qlik.com/t5/QlikView/Null-values-in-data-to-show-as/m-p/239003#M89735 <HTML><HEAD></HEAD><BODY><P>This isn't very helpful, but it looks like a QlikView bug or "feature" to me. Maybe I'm missing something, though. It would be easy enough to replace 0 with "-", but then a legitimate 0 wouldn't display.</P></BODY></HTML> Fri, 30 Jul 2010 23:21:34 GMT https://community.qlik.com/t5/QlikView/Null-values-in-data-to-show-as/m-p/239003#M89735 johnw 2010-07-30T23:21:34Z Null values in data to show as - https://community.qlik.com/t5/QlikView/Null-values-in-data-to-show-as/m-p/239004#M89736 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Plz refer to the attached file for solution.</P><P>In Revenue expression, you have to use formula as</P><P><I></I></P><P></P><P>sum</P><P></P><P>(<B><I>{&lt;Attribute={"Volume"}&gt;}</I></B>[Value] )</P><BR /><BR /> <BR /><BR /> <P>Similarly for Volume as well.</P><P>Happy Thoughts</P><P></P></BODY></HTML> Sat, 31 Jul 2010 07:37:02 GMT https://community.qlik.com/t5/QlikView/Null-values-in-data-to-show-as/m-p/239004#M89736 2010-07-31T07:37:02Z Null values in data to show as - https://community.qlik.com/t5/QlikView/Null-values-in-data-to-show-as/m-p/239005#M89737 <HTML><HEAD></HEAD><BODY><P>Thanks for the response. Unfortunately this is exactly what John mentioned. We can replace the 0 with a -, but now even legitimate 0's are displayed as -.</P><P>Any other ideas? This may indeed be a bug or "feature".</P></BODY></HTML> Sat, 31 Jul 2010 10:21:04 GMT https://community.qlik.com/t5/QlikView/Null-values-in-data-to-show-as/m-p/239005#M89737 pgdavis2 2010-07-31T10:21:04Z Null values in data to show as - https://community.qlik.com/t5/QlikView/Null-values-in-data-to-show-as/m-p/239006#M89738 <HTML><HEAD></HEAD><BODY><P>theres a checkbox in properties in the presentation tab tha says supress ZERO values you must uncheck that</P></BODY></HTML> Thu, 12 Aug 2010 15:54:06 GMT https://community.qlik.com/t5/QlikView/Null-values-in-data-to-show-as/m-p/239006#M89738 2010-08-12T15:54:06Z