topic Re: Bold Zero Values in QlikView

Bold Zero Values

taylor_jesse — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Bold Zero Values

vishsaggi — Mon, 30 Apr 2018 18:16:56 GMT

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?

Re: Bold Zero Values

rwunderlich — Mon, 30 Apr 2018 18:44:47 GMT

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

Re: Bold Zero Values

taylor_jesse — Mon, 30 Apr 2018 18:57:53 GMT

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

Re: Bold Zero Values

vishsaggi — Mon, 30 Apr 2018 19:03:07 GMT

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?