topic Re: Filling in the Gaps (Data) in QlikView https://community.qlik.com/t5/QlikView/Filling-in-the-Gaps-Data/m-p/1197780#M386166 <HTML><HEAD></HEAD><BODY><P><A href="https://community.qlik.com/docs/DOC-3786">Generating Missing Data In QlikView</A></P></BODY></HTML> Thu, 27 Oct 2016 16:37:11 GMT m_woolf 2016-10-27T16:37:11Z Filling in the Gaps (Data) https://community.qlik.com/t5/QlikView/Filling-in-the-Gaps-Data/m-p/1197779#M386165 <HTML><HEAD></HEAD><BODY><P>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 <SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;">Rate_Group</SPAN>. I need to create the tax amount for every asset that exists in the relative <SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;">Rate_Group</SPAN> and to occur at monthly intervals between an <SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;">Acquire_Date</SPAN> and a <SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;">Disposed_Date</SPAN> if it was disposed. </P><P></P><P>I have attached the data as well as the current QVW for reference.</P><P></P><P>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.</P><P></P><P>Hopefully I have explained this clearly, I would sincerely appreciate insights into understating if Qlik can create the data as needed.</P><P></P><P>Thank you.</P></BODY></HTML> Thu, 27 Oct 2016 14:34:09 GMT https://community.qlik.com/t5/QlikView/Filling-in-the-Gaps-Data/m-p/1197779#M386165 2016-10-27T14:34:09Z Re: Filling in the Gaps (Data) https://community.qlik.com/t5/QlikView/Filling-in-the-Gaps-Data/m-p/1197780#M386166 <HTML><HEAD></HEAD><BODY><P><A href="https://community.qlik.com/docs/DOC-3786">Generating Missing Data In QlikView</A></P></BODY></HTML> Thu, 27 Oct 2016 16:37:11 GMT https://community.qlik.com/t5/QlikView/Filling-in-the-Gaps-Data/m-p/1197780#M386166 m_woolf 2016-10-27T16:37:11Z Re: Filling in the Gaps (Data) https://community.qlik.com/t5/QlikView/Filling-in-the-Gaps-Data/m-p/1197781#M386167 <HTML><HEAD></HEAD><BODY><P>Can you help me with my current QVW?</P></BODY></HTML> Thu, 27 Oct 2016 16:56:23 GMT https://community.qlik.com/t5/QlikView/Filling-in-the-Gaps-Data/m-p/1197781#M386167 2016-10-27T16:56:23Z