How to fill value from previous row without script... - Qlik Community

Ratmadeep · ‎2021-05-28

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 · ‎2021-05-28

Check out the Above() function.

-Rob

Ratmadeep · ‎2021-05-28

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

rwunderlich · ‎2021-05-28

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 · ‎2021-05-28

Is it a good solution?

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

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