Bold Zero Values

[taylor_jesse]

Hi

I have an expression that sums the last 12 months values but I will like to either hide the zero values or display dash "-" for zero values.

My expression is

=sum($(vset12months_set) EEHireCount)

Any help to include in this expression that will force 0 values to display nothing or dashes?

Thank you

[vishsaggi]

Where are you displaying these values in a table box or straight or pivot charts?

You can suppress 0 values in Presentation tab Check suppress when values 0.

Does your current expression works?

[rwunderlich · Accepted solution]

The number format pattern provides for three values separated by semicolon.

positive;negative;zero

You can use the third value to specify how you want zeros formatted. For example:

#,##0;(#,00#);-

Using this format mask zeros will display as "-". To display as blanks specify nothing after the second semicolon.

You can use the pattern in the chart Number pane or in the expression itself with a Num() function.

=Num(sum($(vset12months_set) EEHireCount), "#,##0;(#,00#);-"

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

[taylor_jesse]

Hi I tried this but it didn't work. Im also checked the box for suppress values when null and still didn't  work.

[vishsaggi]

Can you share the app you are trying on? And suppress values when null does not work bcoz there are no nulls from that expression, you said you are getting 0's right?