I think you can alter the script in the following post that accumulates data based on a combination of dimensions and dates (http://community.qlik.com/message/16104#16104).
If you reload your table with an 'Order By Date Desc' clause, testing for an AccumulationKey (just date, or date plus relevant dimensions) you should be able to determine when a date is missing and when you have to roll over to the previous date.
Thanks Gysbert for the reply it is working good in one customer but what if there are more then one records in that date like
CLIENT NO, CLIENT NAME, DATE, CCY, PROD TYPE, AMOUNT
011000003, ASDSASDE, 4/1/2012, USD, PBG, "56,987"
010000001, ASDFGDSF, 4/1/2012, USD, FGT, "54,785"
011000007, ADSFE, 4/1/2012, USD, BGO, "56,987"
011000008, FAFOOOASF, 4/1/2012, USD, BGO, "54,785"
011000009, ADSFLLLL, 4/1/2012, USD, BGO, "62,314"
i have tried and did modifications in the script but it didn't work can you please help me in this