Null values in data to show as -

[pgdavis2]

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.

[johnw]

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.

[#3]

Hi,

Plz refer to the attached file for solution.

In Revenue expression, you have to use formula as

sum

({<Attribute={"Volume"}>}[Value] )

Similarly for Volume as well.

Happy Thoughts

[pgdavis2]

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 -.

Any other ideas? This may indeed be a bug or "feature".

[#5]

theres a checkbox in properties in the presentation tab tha says supress ZERO values you must uncheck that