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:

       

      IF(IsNull(SUM(diff_clicks)),0,SUM(diff_clicks))

       

      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.