topic Re: Showing zero as null in QlikView

Showing zero as null

Anonymous — Tue, 04 Jun 2013 14:15:39 GMT

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

Re: Showing zero as null

Gysbert_Wassenaar — Tue, 04 Jun 2013 14:20:47 GMT

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.

Re: Showing zero as null

Anonymous — Wed, 05 Jun 2013 06:27:25 GMT

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>