topic Annual Budget duplicating in App Development https://community.qlik.com/t5/App-Development/Annual-Budget-duplicating/m-p/1542418#M39132 <P>Good Day,</P><P>I have data like the one below. The months is the expenditure per month. The budget is a yearly budget for the Responsibility_Objective_Item combination</P><P>When i do the cross table for the expenditure month, it duplicates the annual budget with the number of expenditure months.</P><P>Please assist. i have attached the qvf</P><TABLE><TBODY><TR><TD>Responsibility</TD><TD>Objective</TD><TD>Item</TD><TD>&nbsp;Yearly Budget&nbsp;</TD><TD>&nbsp;January&nbsp;</TD><TD>&nbsp;February&nbsp;</TD><TD>&nbsp;March&nbsp;</TD><TD>&nbsp;April&nbsp;</TD><TD>&nbsp;May&nbsp;</TD><TD>&nbsp;June&nbsp;</TD></TR><TR><TD>Finacial Governance</TD><TD>FIMS</TD><TD>Basic Salary</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 500.00</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp; 300.00</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 600.00</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 900.00</TD><TD>&nbsp;&nbsp; 1 200.00</TD><TD>&nbsp;&nbsp; 1 500.00</TD><TD>&nbsp;&nbsp; 1 800.00</TD></TR><TR><TD>Finacial Governance</TD><TD>Compliance</TD><TD>Basic Salary</TD><TD>&nbsp;1 000.00</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp; 400.00</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 800.00</TD><TD>&nbsp;&nbsp; 1 200.00</TD><TD>&nbsp;&nbsp; 1 600.00</TD><TD>&nbsp;&nbsp; 2 400.00</TD><TD>&nbsp;&nbsp; 2 800.00</TD></TR><TR><TD>Finacial Governance</TD><TD>FAMS</TD><TD>Basic Salary</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1 500.00</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp; 500.00</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp; 1 000.00</TD><TD>&nbsp;&nbsp; 1 500.00</TD><TD>&nbsp;&nbsp; 2 000.00</TD><TD>&nbsp;&nbsp; 2 500.00</TD><TD>&nbsp;&nbsp; 3 000.00</TD></TR></TBODY></TABLE> Mon, 11 Feb 2019 15:29:30 GMT GaonyadiweK 2019-02-11T15:29:30Z Annual Budget duplicating https://community.qlik.com/t5/App-Development/Annual-Budget-duplicating/m-p/1542418#M39132 <P>Good Day,</P><P>I have data like the one below. The months is the expenditure per month. The budget is a yearly budget for the Responsibility_Objective_Item combination</P><P>When i do the cross table for the expenditure month, it duplicates the annual budget with the number of expenditure months.</P><P>Please assist. i have attached the qvf</P><TABLE><TBODY><TR><TD>Responsibility</TD><TD>Objective</TD><TD>Item</TD><TD>&nbsp;Yearly Budget&nbsp;</TD><TD>&nbsp;January&nbsp;</TD><TD>&nbsp;February&nbsp;</TD><TD>&nbsp;March&nbsp;</TD><TD>&nbsp;April&nbsp;</TD><TD>&nbsp;May&nbsp;</TD><TD>&nbsp;June&nbsp;</TD></TR><TR><TD>Finacial Governance</TD><TD>FIMS</TD><TD>Basic Salary</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 500.00</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp; 300.00</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 600.00</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 900.00</TD><TD>&nbsp;&nbsp; 1 200.00</TD><TD>&nbsp;&nbsp; 1 500.00</TD><TD>&nbsp;&nbsp; 1 800.00</TD></TR><TR><TD>Finacial Governance</TD><TD>Compliance</TD><TD>Basic Salary</TD><TD>&nbsp;1 000.00</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp; 400.00</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 800.00</TD><TD>&nbsp;&nbsp; 1 200.00</TD><TD>&nbsp;&nbsp; 1 600.00</TD><TD>&nbsp;&nbsp; 2 400.00</TD><TD>&nbsp;&nbsp; 2 800.00</TD></TR><TR><TD>Finacial Governance</TD><TD>FAMS</TD><TD>Basic Salary</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1 500.00</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp; 500.00</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp; 1 000.00</TD><TD>&nbsp;&nbsp; 1 500.00</TD><TD>&nbsp;&nbsp; 2 000.00</TD><TD>&nbsp;&nbsp; 2 500.00</TD><TD>&nbsp;&nbsp; 3 000.00</TD></TR></TBODY></TABLE> Mon, 11 Feb 2019 15:29:30 GMT https://community.qlik.com/t5/App-Development/Annual-Budget-duplicating/m-p/1542418#M39132 GaonyadiweK 2019-02-11T15:29:30Z Re: Annual Budget duplicating https://community.qlik.com/t5/App-Development/Annual-Budget-duplicating/m-p/1542441#M39134 <P>In your QVF you reference a "lib://Desktop_Info/Sample_Data.xlsx" which isn't in the QVF.zip file.</P> Mon, 11 Feb 2019 16:08:53 GMT https://community.qlik.com/t5/App-Development/Annual-Budget-duplicating/m-p/1542441#M39134 JustinDallas 2019-02-11T16:08:53Z Re: Annual Budget duplicating https://community.qlik.com/t5/App-Development/Annual-Budget-duplicating/m-p/1542804#M39154 <P>Attached is the Sample_Data file i'm reading from</P> Tue, 12 Feb 2019 09:13:57 GMT https://community.qlik.com/t5/App-Development/Annual-Budget-duplicating/m-p/1542804#M39154 GaonyadiweK 2019-02-12T09:13:57Z