topic Expression - comparing totals cost between 2 date ranges & calculating difference percentage in QlikView https://community.qlik.com/t5/QlikView/Expression-comparing-totals-cost-between-2-date-ranges/m-p/550252#M555183 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>I am looking to produce a straight table which shows by department a comparison between the total costs arising last month (-1) against the total cost arising&nbsp; for the month&nbsp; before (-2) and then show the difference percentage between the 2 months</P><P></P><P>I have the data set - 'costs' and 'creation date', 'creation month' and 'department' (see excel).&nbsp; I would like to build an expression which totals all the costs with a creation date last month and compare this with the total cost with a creation date that falls in the prior month (-2)</P><P></P><P></P><P>How would I develop such an expression? and how do I ensure this continues to roll on as we progress though the year</P><P></P><P>Thanks </P><P></P><P>Rohan </P></BODY></HTML> Thu, 01 Aug 2013 16:02:09 GMT 2013-08-01T16:02:09Z Expression - comparing totals cost between 2 date ranges & calculating difference percentage https://community.qlik.com/t5/QlikView/Expression-comparing-totals-cost-between-2-date-ranges/m-p/550252#M555183 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>I am looking to produce a straight table which shows by department a comparison between the total costs arising last month (-1) against the total cost arising&nbsp; for the month&nbsp; before (-2) and then show the difference percentage between the 2 months</P><P></P><P>I have the data set - 'costs' and 'creation date', 'creation month' and 'department' (see excel).&nbsp; I would like to build an expression which totals all the costs with a creation date last month and compare this with the total cost with a creation date that falls in the prior month (-2)</P><P></P><P></P><P>How would I develop such an expression? and how do I ensure this continues to roll on as we progress though the year</P><P></P><P>Thanks </P><P></P><P>Rohan </P></BODY></HTML> Thu, 01 Aug 2013 16:02:09 GMT https://community.qlik.com/t5/QlikView/Expression-comparing-totals-cost-between-2-date-ranges/m-p/550252#M555183 2013-08-01T16:02:09Z Re: Expression - comparing totals cost between 2 date ranges & calculating difference percentage https://community.qlik.com/t5/QlikView/Expression-comparing-totals-cost-between-2-date-ranges/m-p/550253#M555184 <HTML><HEAD></HEAD><BODY><P>See attached example. If you simply add data for new months the expression will automatically show the last two months. If you select a month then it will show that month and the previous month.</P></BODY></HTML> Thu, 01 Aug 2013 17:05:23 GMT https://community.qlik.com/t5/QlikView/Expression-comparing-totals-cost-between-2-date-ranges/m-p/550253#M555184 Gysbert_Wassenaar 2013-08-01T17:05:23Z