Dash for Zeros, how to get this in QV

[Anonymous]

Hi, all

I"ve checked all posts but alas non of them worked for me,

Number Formatting... Zero's to Dashs | Qlik Community 

A format string like #,##0.00;-#,##0.00;- works for me to show 0's as dashes. In QV a dash is shown, when exported to Excel a dash is also shown, but the underlying value is still a 0.

another thing I learned I can use property like in, not sure if this a way for global setup,  my QV didn't give me a choice for this window.

Removing - (Hyphen) results with in a Text Object

I have in my table field formatted for money, and would like to get physical dash , if it's zero.

This solution worked partially, it hides zero, but doesn't display dashes

$#,##0;-#,##0;

12,000

3,000

-

111

Tx M

[Gysbert_Wassenaar · Accepted solution]

Add a - character after the second ; character:  #,##0;-#,##0;-