Supress zero values but show 0 orders

[Anonymous]

Hi all,

In QlikView I have got a list of all orders of our customers.

The expression is the sum of the revenue. There are some orders which are free and will get a zero value.

In this chart I have checked the option 'Supress zero values', but I would like to see these free orders.

Any options?

Kind regards,

Henco

[swuehl]

Try an expression that returns a value <> 0 for those Orders, like

count(FreeOrders)

or

count({<Value = {0}>} Value)

Then hide this expression in presentation tab (assuming a straight table chart).