Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
how to eliminate the very ugly '-' ,NULL or Missing symbol, from displaying a measure in a table, at a graphic and non-script level.
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))
Perhaps these
Count({$<Field1-={"''"}>} Field2)
or
Sum({$<Field1-={"'-'"}>} Field2)
unfortunately it doesn't work....
it doesn't work....