Rename nulls

[#1]

Hi!

I need to rename '-' in graph.

I understand, how to rename empty field (5.9%), but this doesn't work with '-'.

Also it would be perfect to unite empty fields and '-' (nulls) and rename it.

Thanks in advance!

[simondachstr]

I suggest you do this in the script:

set NullValue='new name';

(Haven't tested it!)

[sasiparupudi1]

change your dimension to a calculated dimension like the following

if(Len(Trim(YourField))=0,'Not Available',YourField)

hth

Sasi

[#4]

I've tried, but with =0 it renames empty fields, but not "-".

[#5]

Have you tried editing this in the database view? Depending on database, you can use case, nvl or if clause to construct null rename.

[miguelbraga]

You can use the powerfull function alt like this:

alt([your field or expression], 'Null Values') this will give null values the label 'Nulls Values'.

Hope it helps you

Regards,

MB

[#7]

thanks, but it doesn't help. I can't understand what is the difference between - and empty fields. All functions change smth in empty, but nothing works with '-'

[simondachstr]

Use the isNull() statement if you really want to implement a conditional statement.

[simondachstr]

You clearly didn't read the post or you don't know how alt() works :)!

[arulsettu]

may be try this

if(IsNull(filed name),'xxx',field name)