replacing a Initial value by last value of last row

[Anonymous]

Hello all,

I am using a pivot table and I have to replace Initial Value by Last value of the previous row at front end?

Any function?

Example:

Date         Initial Value     Sales          ClosingValue

Apr-14        50                   10                 60

May-14        60                  30                 90

June-14       90                  -20                70

like this.......at front end

Regards,

Balraj

[Anonymous]

?????

[anbu1984]

Can you explain your requirement with sample data?

[Anonymous]

already mentioned in example, What I need to get?

[anbu1984]

Do you want to calculate ClosingValue (= Initial value + sales)?

[maxgro]

above(ClosingValue)

or look for chart inter record functions in Qlik online help

[MarcoWedel]

Hi,

one possible solution:

tabSales:
LOAD Date#(Date, 'MMM-YY') as Date,
Sales
Inline [
Date, Sales
Jan-14, 20
Feb-14, 10
Mar-14, 20
Apr-14, 10
May-14, 30
Jun-14, -20
Jul-14, 10
Aug-14, 40
Sep-14, 30
];

hope this helps

regards

Marco