Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Rename nulls

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!

Screenshot_5.png

9 Replies
simondachstr
Valued Contributor III

Re: Rename nulls

I suggest you do this in the script:

set NullValue='new name';

(Haven't tested it!)

sasiparupudi1
Honored Contributor III

Re: Rename nulls

change your dimension to a calculated dimension like the following

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

hth

Sasi

Not applicable

Re: Rename nulls

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

Not applicable

Re: Rename nulls

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
Valued Contributor III

Re: Rename nulls

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

Not applicable

Re: Rename nulls

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
Valued Contributor III

Re: Rename nulls

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

simondachstr
Valued Contributor III

Re: Rename nulls

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

arulsettu
Honored Contributor III

Re: Rename nulls

may be try this

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