Calculating values ​​previous row

[rogeriobarbosa]

hello, I need an expression that calculates the value of always using the previous line, is an example in excel, need to do the same in QlikView.

thank you.

[#2]

look in help for Peek:

Peek('Sales')

[#3]

Hello

Try this:

percentage adjustment * (1 + peek ('Title of the column'))

'Title of the column shall be the title of the red one in your example.

Rgds

[sreenivas]

Hi

Try this

RowNo()*(1+FieldNameB))

[#5]

if you are doing it in the front end, ie a pivot table report use the Above() function

[rogeriobarbosa]

hello, I need to do in the expression could not do using the above help me please

[#7]

Try this one, it works for me:

LOAD [months years],

     [percentage adjustment],

     sale,

     if([percentage adjustment]='',1+peek(Column)) as KEY,

     Column

FROM

[Example (1).xls]

[RedSky001]

If you want this as an expression in a straight table you'll have to use above()

If you use a pivot table you'll have to use above() or before() depending on how you arrange the fields.

Assuming you want to use a straight table

Add [months years] as the dimension then add the following expresssions.

(Ensure [months years]  is sorted correctly)

sale

sum(sale)

adj

sum([percentage adjustment])

calc

if(RowNo()=1,1

  ,Above(calc) * (adj + 1)

  )

sale2

calc * sale

Mark

[rogeriobarbosa]

Thank you, that was exactly what I need.

[RedSky001]

Please can you mark the right answer as "Correct Answer"?  I need the points for my ego

Mark