topic Re: Re: Update 0 or null data with the previous data on Chart in QlikView

Update 0 or null data with the previous data on Chart

Mon, 24 Feb 2014 13:05:09 GMT

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 — Mon, 24 Feb 2014 13:13:41 GMT

Can you please provide an example or your document?

Mon, 24 Feb 2014 13:30:45 GMT

Hello Alessandro

Please find attached a qvw with dummy Data & Chart.

maxgro — Mon, 24 Feb 2014 13:36:49 GMT

dimension Week #

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

sort by Week #

Mon, 24 Feb 2014 13:42:04 GMT

Thanks...this is exactly what i needed