3 Replies Latest reply: Jun 16, 2013 8:31 AM by Vishal Jada RSS

    Propagate values in QlikView column

    Vishal Jada

      Hello fellow QV developers,

       

      Consider the below table:

       

       

      Test
      A
      B
      C

       

      New Column

      Test
      A
      A
      A
      B
      B
      B
      C
      C
      C
      C

       

       

      I'm asked to propogate values in column Test until there is a non-null value. For example, i would like to see A replicated until there is non-null value and B replicated until there is a non null etc.

       

      Kindly guide me as to how i would write a script for such a requirement.

       

      Cheers.

       

      Thomas