topic Re: Replace Zeros with Empty Values in QlikView

Replace Zeros with Empty Values

anuradhaa — Wed, 25 Nov 2020 16:16:04 GMT

I have an expression and sometime the output value is "0". I want to replace it with ""

expression - sum( {$<Type={AAA}>} Hours )

Thanks

Re: Replace Zeros with Empty Values

sunny_talwar — Wed, 19 Oct 2016 10:07:44 GMT

You can use an if statement

If(Sum({<Type = {AAA}>} Hours) > 0, Sum({<Type = {AAA}>} Hours))

Re: Replace Zeros with Empty Values

sunny_talwar — Wed, 19 Oct 2016 10:08:15 GMT

or you can do something like this:

Sum({<Type = {AAA}>} Hours) * (Avg({<Type = {AAA}>} Hours)/Avg({<Type = {AAA}>} Hours))

Re: Replace Zeros with Empty Values

sushil353 — Wed, 19 Oct 2016 10:10:59 GMT

Hi,

You can also try option to suppress 0 values from expression. setting>presentation>suppress zero value option checked in..

Re: Replace Zeros with Empty Values

anuradhaa — Wed, 19 Oct 2016 10:17:32 GMT

I have three columns in my pivot table, when i use this some records were exclude even the >0 values in another coulm.

so If(Sum({<Type = {AAA}>} Hours) > 0, Sum({<Type = {AAA}>} Hours),'')

Solve the issue

Re: Replace Zeros with Empty Values

sunny_talwar — Wed, 19 Oct 2016 10:19:19 GMT

Your three columns are three expressions or are you just using a pivoted dimension with just 1 expression?

Re: Replace Zeros with Empty Values

Anil_Babu_Samineni — Wed, 19 Oct 2016 10:25:01 GMT

Check from Presentation Tab

Re: Replace Zeros with Empty Values

anuradhaa — Wed, 19 Oct 2016 10:37:39 GMT

Yes, You are correct. In one column i'm getting sums of other two columns and that is the column that i have question.

sum(hours) - [col 1] - [col 2].

So my solution also wrong even though it display the raw the values are incorrect. Then i have replace coulm names in the expression with whole expression, then issue resolved.

Thanks Sunny.