Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
robbiewottie
New Contributor II

Showing zero as null

Hi guys,

I want to make a grafic logritmic but these zero values are have to be converted to null.

Whats the correct if statement for this expression?

Orginal statement:

 

sum ({$<Rep_Plant={'V','W'}, Rep_Year={">=$(#=year(today())-1)"}, Rep_YrMnth -= {$(=Date(today(),'YYYYMM') )

Month Turnover

201301 11619989

201302 11629800

201303 11406161

201304 11410011

201305 11193259

201306 0              

201307 0               

201308 0          

201309 0          

201310 0          

201311 0     

201312 0          

Best regards,

Robert

2 Replies

Re: Showing zero as null

Select Fixed to as format on the Number tab of the properties window and then change the Format Pattern to #,##0;#,##0; so 0 values are shown as blanks. Or #,##0;#,##0;- if you want 0 values shown as a hyphen.


talk is cheap, supply exceeds demand
robbiewottie
New Contributor II

Re: Showing zero as null

Hi Gysbert,

Thanks for reply.

This looks okay in de table but de grafics stil ‘see’s’ zero’s.

calculation:

sum({$<Rep_Plant={'V','W'}, Rep_Year={">=$(#=year(today())-1)"}, Rep_YrMnth -= {$(=Date(today(),'YYYYMM') ) }>} Act_MAT_EUR)

Van: Gysbert Wassenaar

Verzonden: dinsdag 4 juni 2013 16:21

Aan: Robert Waterval

Onderwerp: - Re: Showing zero as null

QlikCommunity<http://community.qlik.com/index.jspa>

Re: Showing zero as null

created by Gysbert Wassenaar<http://community.qlik.com/people/gwassenaar> in Development (QlikView Desktop) - View the full discussion<http://community.qlik.com/message/353182#353182>

Community Browser