Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Contributor II

Supress zero values but show 0 orders

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

1 Reply
Highlighted
MVP
MVP

Re: Supress zero values but show 0 orders

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