Ingoing balance in January

Wed, 25 Nov 2020 16:16:04 GMT

Hi.

I have ingoing balance in January and I would like to recreate that for month ahead to be able to calculate each month against ingoing balance. The problem I face is that I would like to splitt it per Site and when I do that the report become not correct.

1. In my first picture I have all the balance in January and is splittet correct per site and I would like to recreate this on each month.

2. In my second picture I try to use total function and then it recreate on each month but with not correction proportions.

3. Do I need to create a variable?

sum({<Account= {"1451","14411","1431","1421","1452"},Month= {"<=$(=max({<Year={$(=Only(Year))}>} Month))"}>}$(Balance))

Regards Mikael

topic Ingoing balance in January in QlikView

Ingoing balance in January