global vision of data available every day

[dvasseur]

Hello,

I have an application dealing with shares, each share having an 'in' date (bought) and an 'out' date (sold) and the value of the share.

Now I would like to display for each calendar date the global value of all shares available at this date.

Data:

share	in (dd/mm/yyyy)	out (dd/mm/yyyy)	value
A	01/01/2008	10/01/2008	10
B	07/01/2008	13/01/2008	30
C	02/01/2008	04/01/2008	20
D	05/01/2008	15/01/2008	40

Result wanted:

01/01/2008	10
02/01/2008	10+20 = 30
05/01/2008	10+40 = 50

I can get it if I select a specific date but not for a global vision

See attached QVW

Regards,

David

[#2]

Hi David,

just an idea. See the attached example for details.

Good luck!

Rainer

[dvasseur]

Hi Rainer,

I have to check if it can be done with my real data (and millions of records updated frequently), I would have prefered a dynamic solution but good idea anyway, thanks!

David