3 Replies Latest reply: Aug 1, 2012 2:59 PM by Anirban Mukherjee RSS

    How to discard null values in Qlikview

      Hi,

       

      I have a straight table with 14 columns consisting of numerical data. In one or two columns I have null data which I represent by the symbol "-". Now, if I write an expression in the 15th column of the straight table as col(1)+col(2)....+col(14) I get the sum as "-".

       

      If I remove the particular columns consisting of the null values, for eg: if col(2) is null (represnted by "-") & I remove it from the expression for summing up as col(1)+col(3)...

      I get the summation value.

       

      How can I discard null values and add up only those columns which has value in it. The values are all numerical.

       

      Thanks to All in advance for suggestions,

      Tutan