topic Re: Nulls in Pivot Table and Bart Chart in QlikView

Nulls in Pivot Table and Bart Chart

0li5a3a — Fri, 06 Jul 2018 10:37:23 GMT

Hi all,

Could someone adivce me how to DON'T display the " -" into the Pivot Table and Bart Chart?

I want to mention that I still want to display the Months with no data in it but I don't want to see this " - " in the legend in the Bart Chart and in Type in the Pivot Table.

Please find the attached files where I have created a scenario.

Kind regards,

Re: Nulls in Pivot Table and Bart Chart

Chanty4u — Fri, 06 Jul 2018 10:41:45 GMT

in dimension

check supres null value .

in presentation tab also do the same

Re: Nulls in Pivot Table and Bart Chart

dapostolopoylos — Fri, 06 Jul 2018 10:44:00 GMT

Re: Nulls in Pivot Table and Bart Chart

0li5a3a — Fri, 06 Jul 2018 10:49:16 GMT

Hi ,

If you do this you would not be able to see Sep, Nov and Dec and I want to be able to see it.

Regards,

Re: Nulls in Pivot Table and Bart Chart

0li5a3a — Fri, 06 Jul 2018 10:50:30 GMT

This is not right, I want to see Sep, Oct, Nov and Dec in my charts.

Re: Nulls in Pivot Table and Bart Chart

0li5a3a — Fri, 06 Jul 2018 10:51:35 GMT

Any guru expers?

Re: Nulls in Pivot Table and Bart Chart

dapostolopoylos — Fri, 06 Jul 2018 10:52:32 GMT

Have you tried to play with the "Show All Values" checkbox?

Re: Nulls in Pivot Table and Bart Chart

0li5a3a — Fri, 06 Jul 2018 12:25:41 GMT

Yes, but stii the same:)

Re: Nulls in Pivot Table and Bart Chart

sergio0592 — Fri, 06 Jul 2018 12:34:42 GMT

Hi, in pivot chart you can manage Missing value/Nul symbol and remove -

Re: Nulls in Pivot Table and Bart Chart

0li5a3a — Fri, 06 Jul 2018 12:49:16 GMT

thnaks for that but still not done,

Re: Nulls in Pivot Table and Bart Chart

sergio0592 — Fri, 06 Jul 2018 13:04:17 GMT

Have you already tried to check "Supress Zero value" in presentation Tab?

Re: Nulls in Pivot Table and Bart Chart

0li5a3a — Fri, 06 Jul 2018 13:33:22 GMT

yes, but if you want to select year 2016,2017 all the months with no data would go. I want o displya even the months with no data in....

Re: Nulls in Pivot Table and Bart Chart

sergio0592 — Fri, 06 Jul 2018 13:53:43 GMT

In your dimension, as a calculated dimension try with :

if(len(Type)>1,Type)

Re: Nulls in Pivot Table and Bart Chart

0li5a3a — Fri, 06 Jul 2018 14:17:19 GMT

stil the same, I am afraid

Re: Nulls in Pivot Table and Bart Chart

BalaBhaskar_Qlik — Fri, 06 Jul 2018 16:47:53 GMT

Include null values - All null values are displayed as gaps or dashes (-).

Uncheck the Populate Missing cells.

Re: Nulls in Pivot Table and Bart Chart

0li5a3a — Mon, 09 Jul 2018 08:11:21 GMT

I have added a test scenario and now you can play with, anyway your solution doesn't work in my case.

Re: Nulls in Pivot Table and Bart Chart

0li5a3a — Mon, 09 Jul 2018 13:43:31 GMT

Hi all,

I come with the solution, please use it in future if you need to exclude the nulls from legends.

Regards, C