topic need monthly data---getting accumulate data in QlikView

need monthly data---getting accumulate data

Wed, 21 Oct 2009 14:43:30 GMT

hello guys,

I need your help around here.

every month I'm getting one file from the users.

(you can see example in the attach files)

the thing is that I need to calculate for every month how much the expenses were but the files

which I receive contain the TOTAL expenses that made untill now.

for ex' (see the attachment ) for ID 'ccc' in month 09/2009 I want to see that his expenses were:

1005-970=35

hope you got me right...

thanx..

Wed, 21 Oct 2009 16:01:10 GMT

Hi David,

see the example to get an idea how it could work in a table.

Maybe a step forward.

Good luck!

Rainer

Wed, 21 Oct 2009 17:13:51 GMT

well thanks BUT

maybe I didn't mention that , I need

to keep the data into a QVD file at the end and not to calculate it over the GUI.

so for every month I need in addition to the column that contains the TOTAL expenses (untill that month)

another column with the expenses of this month only.

Wed, 21 Oct 2009 18:00:14 GMT

Hi,

I have modified it and calculate the difference in script.

See the example.

Rainer

Wed, 21 Oct 2009 21:18:34 GMT

it seems to be working!

thanx !