3 Replies Latest reply: Apr 16, 2012 12:07 PM by langaar9 RSS

    converting nulls to 0 for a column generated by concatanation

    Sonika Jain

      Hi All,

      Am new to Qlikview, am stuck in a scenario where I have loaded two tables (logically one) through concatenation. now, for the columns in second table , the rows corresponding to first table have null (-s). I want to convert these to 0s wherever there is a null, right into the load script.

       

      ISNULL isnt working as nulls are generated through non presence of values during concatenation.

       

      Please provide sugessions.

       

      Thanks in advance