Update 0 or null data with the previous data on Chart

[#1]

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.

[alexandros17]

Can you please provide an example or your document?

[#3]

Hello Alessandro

Please find attached a qvw with dummy Data & Chart.

[maxgro · Accepted solution]

dimension          Week #

expression          if(len(trim(Measure))=0, above(sum(Measure)), sum(Measure))

sort by Week #

[#5]

Thanks...this is exactly what i needed