Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

robbiewottie
Not applicable

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
Gysbert_Wassenaar
Not applicable

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
Not applicable

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>