topic Re: cumulative balance issue.. in QlikView

cumulative balance issue..

sudeep_d — Wed, 12 Sep 2012 06:46:40 GMT

APRIL					MAY
Opening Stock	V1	v2	V3	Balance	Opening Stock	V1	V2	V3	Balance
0	10	5	3	2	2	8	2	2	6

Here The opening stock in the 1st month is 0 and in the second month (i.e may) is the value of balance in previous month(i.e april) and balance is calculate by formula column(1)+column(2)-column(3)-column(4),

where column(1)= opening stock

coluimn(2) =V1

column(3)=V2

column(4) = V3

What should be the expression for the Opening stock(i . e column(1))??

Note: If i select May, the value of opening stock still should remain 2 ,not 0

Any help would be appreciated

Thanks

Sudeep

Re: cumulative balance issue..

Wed, 12 Sep 2012 07:08:06 GMT

Use peek Or Previous .. to get the Balance of Previous month and put the same in the Next Month Opening Stock.

Also let me know wether the same has to be done at back end or front end..

Re: cumulative balance issue..

sudeep_d — Wed, 12 Sep 2012 07:19:21 GMT

Hi Rishi,

Peek and Previous are back end fuctions but i have to calculated it in the front end.

In the above example th e five different columns are 5 diff expressions where v1 v2 v3 are showing count of machines

Thanks

Re: cumulative balance issue..

Jason_Michaelides — Wed, 12 Sep 2012 07:22:30 GMT

I think you'll need a combination of Aggr() and RangeSum() and Above(). Please post your app to make it easier to help you.

Jason