How to fill value from previous row without scripting. Using ony UI

[Ratmadeep]

How to fill value from previous row without scripting without peek or previous. Using ony UI

exp

month   Sales    Result

Jan            100       100

FEb            200       200

Mar                           200

Apr                            200

May            300      300

Jun                           300

Jul                              300

Aug                            300

Sep        100              100

Oct          500             500

Nov                              500

Dec         700            700

I want this result in chart layer/Using straight table without creating any field in script

[rwunderlich]

Check out the Above() function. 

https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/InterReco...

-Rob

[Ratmadeep]

But if continuous two or three row has null value then in which way i can use this above function?

[rwunderlich]

This will handle up to 4 blank rows. If you think you may have more, just add more Above() lines to the expression. 

Alt(only(Sales)
,Above(TOTAL only(Sales))
,Above(TOTAL only(Sales), 2)
,Above(TOTAL only(Sales), 3)
,Above(TOTAL only(Sales), 4)
) 

-Rob

[Ratmadeep]

Is it a good solution?

Cant I do it dynamic instead of writing 2,3,4 ad all?