above works in chart but not in the load skript

[qlikconsultant]

Hi,

I use the following Code in a Chart table:

round(((

above(sum(MyNummber),10)

+above(sum(MyNummber),9)

+above(sum(MyNummber),8)

+above(sum(MyNummber),7)

+above(sum(MyNummber),6)

+above(sum(MyNummber),5)

+above(sum(MyNummber),4)

+above(sum(MyNummber),3)

+above(sum(MyNummber),2)

+above(sum(MyNummber),1)

)/10))

Works fine but I need the value to calculate other values.  So my idea was to calculate this number in the load skript:

round(((

above(sum(MyNummber),10)

+above(sum(MyNummber),9)

+above(sum(MyNummber),8)

+above(sum(MyNummber),7)

+above(sum(MyNummber),6)

+above(sum(MyNummber),5)

+above(sum(MyNummber),4)

+above(sum(MyNummber),3)

+above(sum(MyNummber),2)

+above(sum(MyNummber),1)

)/10)) as myaverage

Unfortunly the code is not working and I have no idea what is wrong.

[Gysbert_Wassenaar · Accepted solution]

The above function works only in charts, as you noticed. In the script you can use the functions previous and peek to get date from earlier rows. Here's a discussion that looks like it might help you with your problem.