Rolling Count

[vpanchuda]

Total materials to be supplied -100

Target dates, Qty

10-07-2019-  50 nos

12-11-2019-20 nos

05-01-2020-10 nos

15-03-2020-20 nos 

I have the target dates and qty loaded in the script, I want to show a bar graph with target dates in X-axis and accumulated quantity in bar charts, how to create expression for this in the chart in Qlik Sense.

The solution should look like.

The first bar Should show 50, Second bar 70,3rd Bar 80, and fourth as 100.

[vpanchuda]

Total materials to be supplied -100

Target dates, Qty

10-07-2019-  50 nos

12-11-2019-20 nos

05-01-2020-10 nos

15-03-2020-20 nos 

I have the target dates and qty loaded in the script, I want to show a bar graph with target dates in X-axis and accumulated quantity in bar charts, how to create expression for this in the chart in Qlik Sense.

The solution should look like.

The first bar Should show 50, Second bar 70,3rd Bar 80, and fourth as 100.

[tresesco]

Try like:

RangeSum(Above( Sum(PurgeChar(trim(Qty),'nos')), 0, RowNo()))

[sunilkumarqv]

Try this: on expression

aggr(RangeSum(Above( Sum(PurgeChar(trim(Qty),'nos')), 0, RowNo())),"Target dates")

script:

Load

Target dates, rangsum(Qty,peek('AccQty')) as AccQty resident table order by Target Dates;

and exp:  sum(AccQty)