Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
kyle_smith_eni
Contributor II
Contributor II

Formatting 0 as - (a single dash)

Hi All,

Hopefully this is easy, but I would like to format 0's in my pivot table as '-', so that they match with the null value fields. In Excel you could do it with a formula like this: #,##0;-#,##0;-

Capture.PNG

Thanks,

Kyle

1 Solution

Accepted Solutions
sunny_talwar

May be do like this

If(Expression = 0, Null(), Expression)

View solution in original post

3 Replies
sunny_talwar

May be do like this

If(Expression = 0, Null(), Expression)

Anonymous
Not applicable

Maybe use an If:

If ( YourExpression = 0 , null() , YourExpression )


Then it actually will be Null().

kyle_smith_eni
Contributor II
Contributor II
Author

Thanks Sunny, that worked perfectly!

It would be great if there were additional formatting options so that 0 could be formatted separately, as in Excel.