Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

adam1988
New Contributor II

How to calculate balance differences between months in chart with time dimension

Hi,

i'm trying to solve this but I dont know how, so I wondering if I'm that stupid or what...

I've got data about customers and balances on their accounts at every last day of the month. It looks this way for example:

periodcustomerbalance
11-2012John255
10-2012John240
09-2012John180
08-2012John150

Users scenario is simple. They filter one PERIOD and see SUM OF BALANCES from all customers. Also, they need to see how this SUM OF BALANCES went throw the time in chart. I use PERIOD as dimension and exppression "sum({$<period=>} balance)" - there is no problem.

From table I can see Johns' amount of money between 08-2012 (150) and 09-2012 (180) increased so the diference in 09-2012 is 30. in 10-2012 is 60 and 11-2012 is 15.

How can I calculate these differences? For one selected month, it's easy "sum({$<period=LastPeriod>} balance)" where LastPeriod = addmonth(period, -1). But how to calculate/add column with DIFFERENCES into previous table? AND primarily, how can I present these differences in chart with period dimension?

Because if I use "sum({$<period=>} balance)" I can't use set analysis for period again.

Is it even possible?

Thx. Adam

Community Browser