I am looking to fill in some gaps in my data while maintaining the integrity of the relationships. My current data model is comprised of a Master Calendar, an Asset description table, and a table with types of expenses that can exist for any given asset. One of these expenses is very high level and not associated by an Asset ID. The taxes are based on a group of assets classified by the Rate_Group. I need to create the tax amount for every asset that exists in the relative Rate_Group and to occur at monthly intervals between an Acquire_Date and a Disposed_Date if it was disposed.
I have attached the data as well as the current QVW for reference.
You will see I have combined the cost transaction tables into one, and I would like the tax table included with the “Monthly Costs” table.
Hopefully I have explained this clearly, I would sincerely appreciate insights into understating if Qlik can create the data as needed.