topic Cummulative Balance in QlikView

Cummulative Balance

Mon, 30 Aug 2010 10:29:26 GMT

Hi all

Appreciate your kind effort to advise how to compute the cummulative balance in 3rd table known as Backlog :

The formula for Actual Backlog in Day 6 should be as follows :

= (Actual Order - Actual Sales) in previous periods (ie.days 3...to 5) + (Actual Order - Actual Sales) in current period (ie. day 6).

Thanks & Best Rdgs

Steven

Cummulative Balance

Miguel_Angel_Baeyens — Mon, 30 Aug 2010 12:07:03 GMT

Hello Steven

If I got your question right, I'd try something like

RangeSum(Above(Sum(Act_Order) - Sum(Act_Sales), 0, NoOfRows()))

Hope that helps!

Cummulative Balance

Tue, 31 Aug 2010 00:40:43 GMT

Hi Miguel A. Baeyens

Thanks for your quick response and kind suggestion, it works well.

Many Thanks & Best Rdgs

Steven

Cummulative Balance

Fri, 03 Sep 2010 02:53:24 GMT

Hi Miguel A. Baeyens

Sorry to trouble you again as your recommendation is only correct for all days within same month (Jul) but it did not add up previous month balances (ie. Jun). Please refer to the attached QV for details.

Thank you in advance for your help.

Many Thanks & Best Rdgs

Steven

Cummulative Balance

Miguel_Angel_Baeyens — Sun, 05 Sep 2010 10:23:48 GMT

Hello Steven,

Try

RangeSum(Above(TOTAL Sum(Act_Order) - Sum(Act_Sales), 0, NoOfRows()))

To sum all possible values in your column, including previous months.

Regards

Re: Cummulative Balance

Phan_Anh_Son — Tue, 09 Jul 2024 15:50:49 GMT

Why is Wrong calculation at Jul 31

Thanks.