4 Replies Latest reply: Feb 24, 2014 8:42 AM by Atish Banerjee RSS

    Update 0 or null data with the previous data on Chart

      Hello All

       

      I am new to QlikView and am having some Issues creating an expression.

       

      in my expression i need to display or auto update sections where there 0 or null data with the previous data

      Example :

       

      Data

      Week #      Measure

      W1          200

      W2          300

      W3          Null

      W4          250

      W5          300

      W6          Null

      W7          Null

      W8          400

       

      Need to be Displayed as

      Week #      Measure

      W1          200

      W2          300

      W3          300

      W4          250

      W5          500

      W6          500

      W7          500

      W8          400

       

      This calculation need to be done on a Chart not on the Load Script.