# New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Valued Contributor

## C/F Becoming B/F

I always need the calculated closing balance to be appeared as opening balances in the next Month. As per my calculation, figures are ok but it is appearing after C/F balance but I need to make it appear in the below row as b/f in February. Can some one help me to achieve this?

Thanks

Neville

1 Solution

Accepted Solutions MVP

## Re: C/F Becoming B/F

Expression for BF

``Sum(Aggr(If(RowNo() = 1, Sum([B/F]), Above(SUM([B/F])+SUM(CONTRIBUTION)-SUM(SETTLEMENT))), BR_CODE, DES, DATE))``

Expression for CF

``Sum(Aggr(If(RowNo() = 1, Sum([B/F]), Above(SUM([B/F])+SUM(CONTRIBUTION)-SUM(SETTLEMENT))), BR_CODE, DES, DATE))+SUM(CONTRIBUTION)-SUM(SETTLEMENT)``

9 Replies
Valued Contributor

## Re: C/F Becoming B/F

Dear Members,Look forward for help

Thanks

Neville MVP

## Re: C/F Becoming B/F

Is this what you are looking to get to? Try this

``````Aggr(
Above(
Sum([B/F]) + Sum(CONTRIBUTION) - Sum(SETTLEMENT)
)
, BR_CODE, DES, DATE)``````

Valued Contributor

## Re: C/F Becoming B/F

Actually, what is ended as C/F in January (10000,2500,12500) needs to be brought forward in February. In other words  in February it should be shown as below

 BR_CODE DATE DES B/F CONTRIBUTION SETTLEMENT C/F RA 1/1/2019 SAL_ADVANE 5000 2500 5000 2500 RA 1/1/2019 TRAVELLING 10000 5000 2500 12500 RA 1/1/2019 ADVANCE 2500 10000 2500 10000 RA 2/1/2019 SAL_ADVANE 2500 5000 1000 6500 RA 2/1/2019 TRAVELLING 12500 5000 1000 16500 RA 2/1/2019 ADVANCE 10000 5000 1000 14000 MVP

## Re: C/F Becoming B/F

This seems to work for 2 dates, but might have to be tuned for multiple dates... Valued Contributor

## Re: C/F Becoming B/F

Thanks sunny for reply. Could you please forward me the expression used to fix the data as in the table you forwarded. I cannot open up your qvd. The formula you sent earlier, didn't help me to arrange the b/f  as I need.Please send me the expression used.

Thanks

Neville MVP

## Re: C/F Becoming B/F

Expression for BF

``Sum(Aggr(If(RowNo() = 1, Sum([B/F]), Above(SUM([B/F])+SUM(CONTRIBUTION)-SUM(SETTLEMENT))), BR_CODE, DES, DATE))``

Expression for CF

``Sum(Aggr(If(RowNo() = 1, Sum([B/F]), Above(SUM([B/F])+SUM(CONTRIBUTION)-SUM(SETTLEMENT))), BR_CODE, DES, DATE))+SUM(CONTRIBUTION)-SUM(SETTLEMENT)``

Valued Contributor

## Re: C/F Becoming B/F

Dear Sunny,

Thanks for the expression. Why the c/f  is not coming to appear in the B/F in February. Could you please see why the closing balance in January (c/f) is no coming to appear in opening balance(b/f) in February.

Thanks MVP

## Re: C/F Becoming B/F

Because you have not updated the expression for BF yet 🙂

Valued Contributor

Tanks Sunny

Neville