topic how to get rolling data in QlikView

how to get rolling data

abc_18 — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have data in excel like below. how to get that output column in qvw

attaching excel file also.

please suggest guys.

formula I have mentioned in excel sheet.

Anil_Babu_Samineni — Tue, 11 Jul 2017 10:14:25 GMT

Like this?

Frank_Hartmann — Tue, 11 Jul 2017 10:16:13 GMT

try this in script:

Previous([running total])+os-cs as OutputNew

MK_QSL — Tue, 11 Jul 2017 10:18:36 GMT

Data:

Load

Date#(MonthYear,'MMM-YY') as MonthYear,

CardYear,

CardMonth,

os,

Inline

[

MonthYear CardYear CardMonth os cs

Jan-14 2014 1 10 29

Feb-14 2014 2 3 25

Mar-14 2014 3 6 19

Apr-14 2014 4 4 24

May-14 2014 5 11 28

Jun-14 2014 6 11 24

] (delimiter is \t);

Dimension

MonthYear

Expresssions

SUM(os)

SUM(cs)

SUM(os)-SUM(cs)

Above(SUM(os)-SUM(cs)) + SUM(os) - SUM(cs)

abc_18 — Tue, 11 Jul 2017 10:36:30 GMT

I have achieved desired output using this formula.

=RangeSum(Above(TOTAL Column(1) - Column(2), 0, NoOfRows(TOTAL)))

how can I include monthyear field in this , so that upon selection of monthyear this column should change.