2 Replies Latest reply: Jun 22, 2012 9:05 AM by Gaurav Malhotra RSS

    Null or Zero

    Gaurav Malhotra

      Hi folks,

      I was loading some data from excel file something like this:

       

       

      ABCD
      P100500
      Q10050
      R10000
      S100

       

       

      So the problem is:

       

      I want to treat " " value as "0" in order to make a calculation.

       

      Regards,

      Gaurav Malhotra

      Qlikview Consultant Trainee