histogram in Qlik sense - exclude values

[MarZu]

Hello,

I calculate a time duration in a field while loading the data in load editor if a condition is satisfied, otherwise I assign the value 0.

Plotting the histogram I get a undesidered huge bar around 0.

How can I exclude the value 0 from the histogram bar?

how already in the expression while loading?

Better would be for me to set those undesiderd value as NaN  but how?

Thanks

[Mark_Little · Accepted solution]

Could set the as NULL() instead on 0 in script 

or normally there is a option for exclude zero in the options