NULL Symbol

[francofiorillo]

how to eliminate the very ugly '-' ,NULL or Missing symbol, from displaying a measure in a table, at a graphic and non-script level.

[Mark_Little]

Hi

Unlike QlikView there isn't just an options to change how Null appears in the table. Only where i have found to do it is add a condtion to the expression that returns what you want to see when a Null value is returned.

Ie. IF(ISNULL(Sum(Sales),0,Sum(Sales))

[BrunPierre]

Perhaps these

Count({$<Field1-={"''"}>} Field2)

or

Sum({$<Field1-={"'-'"}>} Field2)

[francofiorillo]

unfortunately it doesn't work....

[dncontin]

try

alt(field,0)

more info

alt - script and chart function

[francofiorillo]

it doesn't work....