Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

Empty Values to 0

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.

empty.PNG

Tags (4)
4 Replies
rahulpawarb
Valued Contributor II

Re: Empty Values to 0

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

Not applicable

Re: Empty Values to 0

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
Valued Contributor II

Re: Empty Values to 0

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
Valued Contributor III

Re: Empty Values to 0

Community Browser