topic Re: Running Total using Rangesum in App Development

Running Total using Rangesum

srini — Fri, 02 Aug 2019 11:52:55 GMT

Hi Friends,

Very good Day!

I am using the below expression to get the running accumulative total till current month.

Rangesum(above(Count({$<DueMonthName = {"<$(=Date(Today(), 'MM/DD/YYYY'))"}>}[Issue id]),0,RowNo()))

I am getting the result till current month but for rest of future months it is taking the current month total instead of zero.

Re: Running Total using Rangesum

premvihari — Fri, 02 Aug 2019 12:38:14 GMT

Rangesum will show sum of the values of all the rows above with current row.. Please note that below expression will show 0 for future months hence range sum will repeat the same value as of current month for the following months. Count({$}[Issue id])

Re: Running Total using Rangesum

premvihari — Fri, 02 Aug 2019 13:03:42 GMT

Re: Running Total using Rangesum

srini — Mon, 05 Aug 2019 05:27:10 GMT

Hi Prem,

But the expression is only giving the particular month count. I need to have the running total i.e. previous month count should be added to the current month.

Re: Running Total using Rangesum

miskinmaz — Mon, 05 Aug 2019 05:42:54 GMT

Can you post the base table showing only month, it's actual count and the running total count.

Re: Running Total using Rangesum

srini — Mon, 05 Aug 2019 05:45:34 GMT

please have look.

Re: Running Total using Rangesum

miskinmaz — Mon, 05 Aug 2019 05:48:43 GMT

post the column for expression: Count({$<DueMonthName = {"<$(=Date(Today(), 'MM/DD/YYYY'))"}>}[Issue id])

this will give you the count for every month and from this we can debug it further.

Or else post the sample app

Re: Running Total using Rangesum

srini — Mon, 05 Aug 2019 06:03:36 GMT

Hi Friend,

I am ultimately looking for this output.

Output table from excel

Right now I am getting this one in Qlik Sense

I have used the

Expression:

First measure: Rangesum(above(Count({$<DueMonthName = {"<$(=Date(Today(), 'MM/DD/YYYY'))"}>}[Issue id]),0,RowNo()))

Second measure: Count(Total([Issue id]))-Rangesum(above(Count({$<DueMonthName = {"<$(=Date(Today(), 'MM/DD/YYYY'))"}>}[Issue id]),0,RowNo()))

but it is not giving me the desired output. Really appreciate your help!

Re: Running Total using Rangesum

srini — Mon, 05 Aug 2019 08:40:43 GMT

Hi Friends,

I have tried a bit with following expression I have got positive result but it is not showing exactly.

Rangesum(above(Count({$<DueMonthName = {"<$(=Date(Today(), 'MM/DD/YYYY'))"}>}[Issue id]),0,RowNo()), IF(DueMonthName = MonthName(Today()),0))

Result:

the cumulative is taken for Aug 2019 only. Then again it starts from November 2019. it is not consecutive.