topic How do I create a financial year/period comparison table? in QlikView https://community.qlik.com/t5/QlikView/How-do-I-create-a-financial-year-period-comparison-table/m-p/200869#M503282 <HTML><HEAD></HEAD><BODY><P>I want to create a Straight Table chart that shows something like the following:</P><P>Period Period Sales 2009/10 YTD Sales 2009/10 Period Sales 2008/09 YTD Sales 2008/09 Period % Increase YTD % Increase</P><P>01 Jul £2705.55 £2,705.55 £606.00 £606.00 346.46% 346.46%</P><P>02 Aug £746.65 £3,452.20 £699.00 £1,305.00 6.82% 164.54%</P><P>02 Sep £430.60 £3,882.80 £2,247.00 £3,552.00 -80.84% 9.31%</P><P>etc</P><P>etc</P><P>And then a total of the 2 year's values accumulated at the bottom.</P><P>In my data I have the following fields:</P><UL><LI>PeriodNo</LI><LI>PeriodName</LI><LI>FinancialYear</LI><LI>ExtendedInvoicePrice</LI></UL><P>Could someone point me in the right direction of what the best way of achieving this would be please?</P><P>Many thanks.</P><P>Andrew Longland</P></BODY></HTML> Thu, 24 Jun 2010 15:13:45 GMT 2010-06-24T15:13:45Z How do I create a financial year/period comparison table? https://community.qlik.com/t5/QlikView/How-do-I-create-a-financial-year-period-comparison-table/m-p/200869#M503282 <HTML><HEAD></HEAD><BODY><P>I want to create a Straight Table chart that shows something like the following:</P><P>Period Period Sales 2009/10 YTD Sales 2009/10 Period Sales 2008/09 YTD Sales 2008/09 Period % Increase YTD % Increase</P><P>01 Jul £2705.55 £2,705.55 £606.00 £606.00 346.46% 346.46%</P><P>02 Aug £746.65 £3,452.20 £699.00 £1,305.00 6.82% 164.54%</P><P>02 Sep £430.60 £3,882.80 £2,247.00 £3,552.00 -80.84% 9.31%</P><P>etc</P><P>etc</P><P>And then a total of the 2 year's values accumulated at the bottom.</P><P>In my data I have the following fields:</P><UL><LI>PeriodNo</LI><LI>PeriodName</LI><LI>FinancialYear</LI><LI>ExtendedInvoicePrice</LI></UL><P>Could someone point me in the right direction of what the best way of achieving this would be please?</P><P>Many thanks.</P><P>Andrew Longland</P></BODY></HTML> Thu, 24 Jun 2010 15:13:45 GMT https://community.qlik.com/t5/QlikView/How-do-I-create-a-financial-year-period-comparison-table/m-p/200869#M503282 2010-06-24T15:13:45Z