Empty Values to 0

[#1]

Hey there!

I've got a pivot table with some information. But there are some 'empty' places. I want them to be 0. But nothing works.

It isn't recognized as null.

[rahulpawarb]

Hello,

Trust that you are doing well!

You can fix this problem by setting Missing Symbol to 0 (i.e. Zero) available on Presentation tab of chart object.

Refer attached sample application.

Regards!

Rahul

[#3]

I apologize, I forgot to mention that I am using Qlik Sense.

This option is not included there on Presentation tab.

It would be nice if you could give advice on how to fix it in Qlik Sense.

[rahulpawarb]

Hello Илья Процик,

I am not sure how to handle it in Qlik Sense. BTW, if I came across similar situation then I will revert.

Regards!

Rahul

[beck_bakytbek]

Hi Ilja,

look at this.

1. https://www.youtube.com/watch?v=l20fjOQgbRc

2. https://www.youtube.com/watch?v=pGpdfMpmWoE

I hope that helps

Beck