Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

kyle_smith_eni
New 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

Tags (1)
1 Solution

Accepted Solutions
MVP
MVP

Re: Formatting 0 as - (a single dash)

May be do like this

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

3 Replies
MVP
MVP

Re: Formatting 0 as - (a single dash)

May be do like this

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

Re: Formatting 0 as - (a single dash)

Maybe use an If:

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


Then it actually will be Null().

kyle_smith_eni
New Contributor II

Re: Formatting 0 as - (a single dash)

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.