topic Re: Number Formatting... Zero's to Dashs in QlikView https://community.qlik.com/t5/QlikView/Number-Formatting-Zero-s-to-Dashs/m-p/495809#M1134237 <HTML><HEAD></HEAD><BODY><P>A format string like <EM>#,##0.00;-#,##0.00;-</EM> 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.</P></BODY></HTML> Sat, 09 Nov 2013 10:28:47 GMT Gysbert_Wassenaar 2013-11-09T10:28:47Z Number Formatting... Zero's to Dashs https://community.qlik.com/t5/QlikView/Number-Formatting-Zero-s-to-Dashs/m-p/495805#M1134233 <HTML><HEAD></HEAD><BODY><P>I'd like to display zero values as a dash similar to what I can do with an Excel spreadsheet with a format similar to </P><P></P><P>"_(* #,##0.00_);_(* (#,##0.00);_(* "-"??_);_(@_)"</P><P></P><P>So far I haven't found any good way to do this in Qlikview besides replacing the zero value in the expression with a dash.&nbsp; This is far from ideal as I'd like to retain the actual zero value when exported to Excel.</P><P></P><P>Thoughts??</P></BODY></HTML> Thu, 07 Nov 2013 23:50:31 GMT https://community.qlik.com/t5/QlikView/Number-Formatting-Zero-s-to-Dashs/m-p/495805#M1134233 2013-11-07T23:50:31Z Re: Number Formatting... Zero's to Dashs https://community.qlik.com/t5/QlikView/Number-Formatting-Zero-s-to-Dashs/m-p/495806#M1134234 <HTML><HEAD></HEAD><BODY><P>Maybe replace zero with Null(). It's not the same although...</P><P></P><P>- Ralf</P></BODY></HTML> Fri, 08 Nov 2013 00:01:32 GMT https://community.qlik.com/t5/QlikView/Number-Formatting-Zero-s-to-Dashs/m-p/495806#M1134234 rbecher 2013-11-08T00:01:32Z Re: Number Formatting... Zero's to Dashs https://community.qlik.com/t5/QlikView/Number-Formatting-Zero-s-to-Dashs/m-p/495807#M1134235 <HTML><HEAD></HEAD><BODY><P>Not looking for nulls since I want the zeo to export to Excel.</P></BODY></HTML> Fri, 08 Nov 2013 22:37:02 GMT https://community.qlik.com/t5/QlikView/Number-Formatting-Zero-s-to-Dashs/m-p/495807#M1134235 2013-11-08T22:37:02Z Re: Number Formatting... Zero's to Dashs https://community.qlik.com/t5/QlikView/Number-Formatting-Zero-s-to-Dashs/m-p/495808#M1134236 <HTML><HEAD></HEAD><BODY><P>you could modify the expression used in the attachment.</P></BODY></HTML> Sat, 09 Nov 2013 05:44:10 GMT https://community.qlik.com/t5/QlikView/Number-Formatting-Zero-s-to-Dashs/m-p/495808#M1134236 2013-11-09T05:44:10Z Re: Number Formatting... Zero's to Dashs https://community.qlik.com/t5/QlikView/Number-Formatting-Zero-s-to-Dashs/m-p/495809#M1134237 <HTML><HEAD></HEAD><BODY><P>A format string like <EM>#,##0.00;-#,##0.00;-</EM> 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.</P></BODY></HTML> Sat, 09 Nov 2013 10:28:47 GMT https://community.qlik.com/t5/QlikView/Number-Formatting-Zero-s-to-Dashs/m-p/495809#M1134237 Gysbert_Wassenaar 2013-11-09T10:28:47Z