Unexpected null in pie chart - how do i remove ?

[#1]

Qlikview 11 for developers, Page 343 -

I see a null or - in my pie chart. How do I find the source of the problem and fix it ? The book does not get it. QVW file attached.

[#2]

Hi, John.

that is Your data couldn't match 100%,,

just removing is [Properties] - [dimensions] - Suppress When Value Is Null ].

[satishkurra]

Hi

Please follow the below navigation to resolve this NULL...

Chart Properties  -----> Go to Dimensions Tab  -----> For the selected dimensions on right side, Please check Supress When Value is Null ---  > Click Apply   ----> Click OK.

Now see that NULL values has been removed from chart.

Thanks

Satish

[its_anandrjs]

You can remove 0 or null values in dimension like

If(len([Carrier Group])>0,[Carrier Group])