topic Re: Not able to show Nulls in QlikView

Not able to show Nulls

kishorj1982 — Tue, 12 Sep 2017 13:22:03 GMT

Hi all,

PFA.

When ever I am selecting prior perid nulls are displayed.But when I am selecting current and prior period both, I could not show the nulls.

after clearing all also nulls are not there.

could you please suggest on this.

thanks !

Re: Not able to show Nulls

sunny_talwar — Tue, 12 Sep 2017 13:26:40 GMT

I guess this is because you show Year dimension only when you select Prior period... is that something you need only when Prior Period is selected?

Re: Not able to show Nulls

sunny_talwar — Tue, 12 Sep 2017 13:28:04 GMT

Check if this works where Year shows up even when both Current Period and Prior Period is selected

Re: Not able to show Nulls

kishorj1982 — Wed, 13 Sep 2017 09:05:10 GMT

Hi Sunny,

Thanks for the reply.

I need to show all the hierarchy after selecting both the option along with nulls.In your previous reply only year is displayed after selecting both option but the output is as excepted what we need.

Thanks,