topic Reference previous value in straight table in QlikView

Reference previous value in straight table

Dayna — Wed, 28 Feb 2018 09:13:31 GMT

Hi All,

I know of Peek() and Previous() in the script, but can you use similar functionality in charts and tables?

i.e. I want to use a previous value in a table, but this value is created from different sources and can't be done in the script, the end result should look like this:

Date	Value	Combined (Value + Previous Combined)
01/01/2018	100	100
02/01/2018	100	200
03/01/2018	50	250
04/01/2018	60	310
...

The idea is, that I can then do an average of this value, but always including the value from the row before.

Previous seems right, but I gather this is only for script and based on ordered data. Any suggestions you can offer would be appreciated.

Kind Regards,

Dayna

Re: Reference previous value in straight table

sunny_talwar — Wed, 28 Feb 2018 10:09:33 GMT

You can use Missing Manual - Above() and Below()

For your specific question, you cna try like this

RangeSum(Above(Sum(Value), 0, RowNo()))

Also, look here

Calculating rolling n-period totals, averages or other aggregations

Re: Reference previous value in straight table

niclaz79 — Wed, 28 Feb 2018 10:26:05 GMT

Hi,

As described above the Above and Below functions do the same as Previous and Peek.

Worth to mention is if you have a pivot with some dimensions as columns, you use the Before and After functions instead to move left or right in the table.

Re: Reference previous value in straight table

Dayna — Wed, 28 Feb 2018 14:35:18 GMT

Thanks all!!