topic Null values - Remove in QlikView

Null values - Remove

priyarane — Wed, 30 Sep 2015 14:12:52 GMT

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.

Re: Null values - Remove

avinashelite — Wed, 30 Sep 2015 14:41:03 GMT

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

Re: Null values - Remove

priyarane — Wed, 30 Sep 2015 14:48:22 GMT

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

Re: Null values - Remove

avinashelite — Wed, 30 Sep 2015 14:51:48 GMT

can you share your app with sample data will see

Re: Null values - Remove

Chanty4u — Wed, 30 Sep 2015 15:02:09 GMT

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

Re: Null values - Remove

priyarane — Wed, 30 Sep 2015 15:41:29 GMT

Hi Avinash,

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