Null values - Remove

[priyarane]

Hi Community,

In one of my dimension, I have null values and some the data is releated to that when I Uncheck suppress when null then null is going out from the Dimension and data is also going go out but I need data and Null should not appear.

PFA for clear understand.

[avinashelite]

I did not get you exact requirement... I feel its behaving correctly..because you have only one expression so if you say suppress expression not data its contrasting ..see data has no value hence your seeing the null value associated with the expression if you suppress null it will obviously suppress the  null data too

[priyarane]

Yes Avinash, But just wanted to hide that Null from the Table(Pivot).

[avinashelite]

can you share your app with sample data will see

[Chanty4u]

Hi priya,

If you do not want to show dashes for NULL – you’d rather have a zero – then you can turn on a

chart setting that populates missing cells (Chart Properties -> Presentation -> Populate missing

cells). Then an internal virtual table will be generated and missing values will be populated with

NULLs.

suresh chanty

[priyarane]

Hi Avinash,

Its a data isssue,, and I am just looking to hide that Null value for time being.