topic Unexpected null in pie chart - how do i remove ? in QlikView

Unexpected null in pie chart - how do i remove ?

Thu, 24 Apr 2014 00:26:35 GMT

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.

Re: Unexpected null in pie chart - how do i remove ?

Thu, 24 Apr 2014 00:52:07 GMT

Hi, John.

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

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

Re: Unexpected null in pie chart - how do i remove ?

satishkurra — Thu, 24 Apr 2014 05:01:24 GMT

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

Re: Unexpected null in pie chart - how do i remove ?

its_anandrjs — Thu, 24 Apr 2014 05:03:17 GMT

You can remove 0 or null values in dimension like

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