topic Re: Empty Values to 0 in App Development

Empty Values to 0

Mon, 24 Apr 2017 09:28:04 GMT

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 — Mon, 24 Apr 2017 11:27:33 GMT

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

Mon, 24 Apr 2017 14:29:33 GMT

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 — Tue, 25 Apr 2017 05:26:32 GMT

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 — Wed, 17 May 2017 13:28:05 GMT

Hi Ilja,

look at this.

I hope that helps

Beck