8 Replies Latest reply: Jan 31, 2014 2:14 PM by Srinivasa Devadiga RSS

    Substitute Zero for NULL Value

      I just can't make heads or tails of Qlikview, nothing ever seems to make sense in this tool. 


      I have a field which may contain NULL values.  They display in my pivot table as a "-" which I do not want.  In SSRS or any other tool I can write an expression to handle this and change the "-" to 0.  How do I do this in Qlikview?


      Right now i'm doing the following:




      But this does not work, I still get the "-" in the fields where there is no number.


      I need someone, in plain English and easy to follow steps, to explain to me how to do this.