Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
"_(* #,##0.00_);_(* (#,##0.00);_(* "-"??_);_(@_)"
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. This is far from ideal as I'd like to retain the actual zero value when exported to Excel.
Thoughts??
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.
Maybe replace zero with Null(). It's not the same although...
- Ralf
Not looking for nulls since I want the zeo to export to Excel.
you could modify the expression used in the attachment.
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.