It may be sufficient to add a master calendar to your model which includes all the dates from a minimum to a maximum date. The calendar should be kept in a separate table and associated with the transaction date. I prefer this to adding fake zero value transactions as these affect counts and averages.
There are many links here if you search for "master calendar".
Can you clarify what exactly you want?
Can you provide your required result also?
May be enclosed file is near what you want...
Warehouse Stock by Day.qvw 137.8 K
I think a way is to cross join the field Date, Account, Item (cartesian product)
load * inline [
Date , Account , Item , QTY , Cost
D1 , A1 , I1 , 10, 10
D1 , A2 , I2 , 50 , 100
load Distinct Date Resident Input;
join (Tmp) LOAD Distinct Account Resident Input;
join (Tmp) LOAD Distinct Item Resident Input;
Left join (Tmp) load * Resident Input;
Date , Account , Item ,
alt(QTY,0) as QTY , alt(Cost,0) as Cost
DROP Table Input, Tmp;