Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

dewan_abdullah
New Contributor

Include Zero values is replacing the 0 with Null Value?

Capture2.JPGCapture.JPG

After unchecking the "Include Zero Values" in the data handling section the zero is replaced with a null?!. The row with '0' or  ' - ' in the Totals Column should disappear.

I tried replacing the null with 0 functions but there is no use.

Please suggest a solution to this thanks.

2 Replies
MVP
MVP

Re: Include Zero values is replacing the 0 with Null Value?

Suppressing zeros only applies if all the values are either null or zero. So the rows display because there are non zero values in the details.

dewan_abdullah
New Contributor

Re: Include Zero values is replacing the 0 with Null Value?

Actually i had some rows that had both 0 as well as Null value and it appeared as 0 in the totals and it wasn't included when i checked the button.

Thanks