topic Re: Rolling Count in App Development

Rolling Count

vpanchuda — Sat, 16 Nov 2024 20:54:02 GMT

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.

Re: Rolling Count

tresB — Fri, 10 May 2019 08:12:11 GMT

Try like:

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

Re: Rolling Count

sunilkumarqv — Fri, 10 May 2019 09:00:40 GMT

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)