Null Value in Chart

[#1]

Hi

I have created a chart and on the axis is organisation, e,g A, B and then there is -.  In the table i have been able to use the presentation option to set this to Unknown. How can i do this on a chart?

Thanks

[bbi_mba_76]

Hi,

in the dimension tab of the chart you could set the suppress when value is null.

[#3]

Thanks for that but that actually removes this from the chart. 

What i want is for this to be displayed but to replace the - with the word Unknown.

[bbi_mba_76]

maybe

if(len(organisation)>0, organisation, 'Unknow')

[jaimeaguilar]

Hi,

There's a function called NullAsValue, which lets you substitute null values with a desired text, so you can select and trace them.

In Script you can type something like this:

NULLASVALUE FieldName1, FieldName2, ... , FieldNameN; //Here you define which fields will have text instead of missing/null

Set NullValue = 'Unknown'; // Write whatever text you want for missing/null values

After this, just load all the tables you need,

Regards

[sureshbaabu]

Hello,

please try the following

=if(isnull(organisation),'unknown',organisation)

Hope it helps!!!

Thanks

[#7]

Hi,

Attaching qlikview file displaying gap where null is present. In this i am presenting two approaches.

Regards,

Abhishek.

[amit_saini]

Hi ,

Please try this:

=if(IsNull(Field),'unknown',Field)

Thanks,

AS

[#9]

Hi,

see the image.

Modify Null Symbol box as your wish like Unknown.

Regards

Kumar

[PrashantSangle]

Hi,

You can achieve this by,

go to Chart Properties->Presentation -> Missing Symbol and Null Symbol->write 'Unknown'

Regards,