Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Ingoing balance in January

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

0 Replies