Balance at start date & Balance at date

[#1]

Hello everyone,

I make cash flow report in pivot chart, and follow sum(amount) on position and month of the current year.

For checking, I want to follow in the same table Balance at start date and Balance at end date, where Balance at start date are sum of amount all transaction until start of that month.

For example, balance at start date of january will be sum of amount all transaction before 01.01.2014, balance of end date in January will be sum of amount all transaction before 01.02.2014 and so on...

But I can't force qlikview to show me transaction before january in januar.

I try with set analysis, and it looks like set analysis can't help me.What can I do to solve problem like this?

Tnx

[MK_QSL]

Create a StartDate and EndDate flag in the script..

Set Analysis can consider date once in a chart not every line level.

If possible, provide sample data to work on this.