topic Re: Displaying of Zero values in QlikView

Displaying of Zero values

Sun, 17 May 2015 17:38:26 GMT

Hi Community,

I was asked to show zero values as null ( - ) . then i should write each expression as

if(sum(Amount)=0,null(),sum(Amount))

But the problem is i am having almost 15 expressions, so i guess it is not a good option. Is there a way to show zero as null?

Re: Displaying of Zero values

Anonymous — Sun, 17 May 2015 18:20:19 GMT

Besides that showing 0 as null is misleading, I don't see problems with your approach.

Re: Displaying of Zero values

Anonymous — Sun, 17 May 2015 18:30:37 GMT

What I have done on occasion is use a Text Color expression on the expression itself to set the text color to the same color as the background so it becomes invisible when zero. :

if(sum(Amount)=0,White())

Re: Displaying of Zero values

Anonymous — Sun, 17 May 2015 18:49:30 GMT

Just had thought, you could use this for as an Integer Number Format to display zero as -

#,##0;-#,##0;-

Or this to display it as blank, the easily missed semi colon at the ended is needed

#,##0;-#,##0;

Re: Displaying of Zero values

Sun, 17 May 2015 19:39:24 GMT

As it is a detail report, there are so many Dollar amounts and most of the values are 0's. So to get the values be iconic they asked to suppress zero dollar amount($0.00).

Re: Displaying of Zero values

Sun, 17 May 2015 19:42:28 GMT

It's a good idea. Thank you...

Re: Displaying of Zero values

Sun, 17 May 2015 19:43:32 GMT

This can't be applied in my situation as i have summation of multiple age band values...

Re: Displaying of Zero values

Anonymous — Sun, 17 May 2015 22:15:20 GMT

It does make sense, but you still can use a presentation which is not misleading. I'd better go with the "color" suggestion from bill.markham‌ above with one minor difference - use light color for the zero-values, e.g.

if(sum(Amount)=0,rgb(200,200,200))

Re: Displaying of Zero values

Mon, 18 May 2015 02:49:16 GMT

Yes, I will use it. I will suggest this one too. Thank you for guiding me in right path..