data transform

Fri, 23 Apr 2010 13:56:47 GMT

Is there an easy way to manipulate the raw data in Qlik to get to where I want to be?

This is the raw corporate data:

contract ID	month	rent	interest
a123	Apr-10	500	25
a123	May-10	500	25
a123	Jun-10	500	25
a123	Jul-10	500	25
a123	Aug-10	500	25
a123	Sep-10	500	25
a123	Oct-10	500	25
a123	Nov-10	500	25

I need to transform it to this in the data load:

month	This Month Balance	Next Month Balance
Apr-10	4200	3675
May-10	3675	3150
Jun-10	3150	2625
Jul-10	2625	2100
Aug-10	2100	1575
Sep-10	1575	1050
Oct-10	1050	525
Nov-10	525	0

This month balance is the total of all rent + interest from that month and
the next month balance is the same calculation less the rent and interest in that month.

Any ideas would be much appreciated.

Many thanks,

Phil

data transform

Tue, 27 Apr 2010 06:07:15 GMT

hi philryan,

pls see the attached application.

probably this is what you want.

thanks

topic data transform in QlikView

data transform

data transform