need to display only null values in chart

[Srinivas]

Hi All,

We need to display only null values in fronted chart,this is the requirement according to that i have created, for i wrote below expression

(if(IsNull([Product Number])=-1 ,'' , Null())   , I can find all null values ,But some product still shows values those are 950093 ,552825 ,552824 and 552823  this wrong , my answer is if have value we need to hide that entire row Please below screen shot.

Could you please help me.

Advance Thanks

Munna

[Chanty4u]

try

=if(len(trim([Product Number]))=-1, 'Null())',

[jagan]

Hi,

Try this expression, no need of calculated dimension

=Sum({<[Product Number]-={'*'}>} MeasureName)

Note: Replace MeasureName with your actual field name.

REgards,

jagan.

[tamilarasu]

Hi,

You can try,

=If(Len(Trim([Product Number]))=0,'')

[sasikanth]

HI,

Try this expression

Sum({1-<[Product Number]={'*'}>}Measure)

[Chanty4u]

and  give

SET Nullvalue = '';

NULLASVALUE *;

• Re: Null values in tables

[pavan045]

Hi Srinivas,

what is the name of the first column in your table??..if that first column is any key for that table (if not a measure), then use below expression instead of your first column as caluculated dimension.

(if(IsNull([Product Number])=-1 ,'your first column name here')

Hope this will help..