topic Delta Calculations in QlikView

Delta Calculations

xtrimf — Sun, 02 Aug 2009 19:33:59 GMT

Hi,

I've ecountered a difficult (I think) problem.

The Table : Date, Item, stock

on the same date there can be several stock updates for a specific Item.

I need to calculate the delta of the stock between date and previous date.

the problem is that If i'm on Jun-01-2009, it does not mean that on Jun-01-2009 there was an update...

I need to find the last perofmed update for any given row / date and then calculate the delta...[:|]

Any Ideas?

Mon, 03 Aug 2009 14:49:40 GMT

Hi,

how you are able to identify if an update was made or not?

Are a kind of flag available?

Rainer

xtrimf — Tue, 04 Aug 2009 17:33:25 GMT

I need to find out if there was an update, and when was the last one before my current position....

Tue, 04 Aug 2009 17:45:21 GMT

Hi,

here are an example to find the last record in a list. See the script for more details.

Maybe it´s a hint to find a solution.

Rainer

xtrimf — Tue, 04 Aug 2009 18:21:23 GMT

Maybe its close...

The calc should be done in a script for each row!

for example, the data you entered for doc 112: (underlined what the new status SHOULD be)