Suppressing 0.00 currency values

feign3 — Sat, 01 Jan 2022 18:26:35 GMT

I'm displaying data in a straight table in which I need to suppress rows with Quantity values of zero as well as Unit Price values that display as 0.00. The "Suppress Zero-Values" did not work for this so I've made the following entry in my dimension to hide rows with Quantity = 0, which works perfectly:

=if([Transactions.Quantity]>0, [Customer.Sales Rep Full Name] , Null())

However, when I use the same logic with the Unit Price value, rows are not suppressed at all OR all rows are suppressed (depending on which method below is used).

The following does not suppress anything:

=if([Transactions.Unite Price]>0, [Customer.Sales Rep Full Name] , Null())

I have tried the following checking for NULL instead (incorrectly suppresses all rows):

=if([Transactions.Unit Price]<>Null(), [Customer.Sales Rep Full Name] , Null())

Also tried checking for NULL the following way, using "len" (incorrectly suppresses all rows):

=if(len([Transactions.Unit Price]>0), [Customer.Sales Rep Full Name] , Null())

Any other ideas on what I might try for this?

Re: Suppressing 0.00 currency values

_Gerardo_ — Sun, 02 Jan 2022 16:43:45 GMT

Hello, could you please attach a sample version of your document? So we can take a look on it and solve your specific issue.

topic Suppressing 0.00 currency values in QlikView

Suppressing 0.00 currency values

Re: Suppressing 0.00 currency values