topic Re: Find diff between month to month Expense in QlikView https://community.qlik.com/t5/QlikView/Find-diff-between-month-to-month-Expense/m-p/121057#M752284 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG>Expense/Above(Expense) - 1</STRONG></P></BODY></HTML> Fri, 19 Oct 2018 14:14:50 GMT sunny_talwar 2018-10-19T14:14:50Z Find diff between month to month Expense https://community.qlik.com/t5/QlikView/Find-diff-between-month-to-month-Expense/m-p/121056#M752283 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P></P><P>I have data as below</P><P></P><P><STRONG>Period&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </STRONG><STRONG>Expense&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Period % Change</STRONG></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">P9&nbsp;&nbsp; 2017&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12,000</SPAN></P><P>P10 2017&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 13,000</P><P>P11 2017&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10,000</P><P>P12 2017&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 11,000</P><P>P1&nbsp; 2018&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 11,000</P><P>P2&nbsp; 2018&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12,000</P><P>P3&nbsp; 2018&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 11,000</P><P>P4&nbsp; 2018&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 11,000</P><P></P><P></P><P>How to I find the Expense % Difference between 2 periods ? </P><P></P><P>Thank you much</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Find-diff-between-month-to-month-Expense/m-p/121056#M752283 apthansh 2020-11-25T16:16:04Z Re: Find diff between month to month Expense https://community.qlik.com/t5/QlikView/Find-diff-between-month-to-month-Expense/m-p/121057#M752284 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG>Expense/Above(Expense) - 1</STRONG></P></BODY></HTML> Fri, 19 Oct 2018 14:14:50 GMT https://community.qlik.com/t5/QlikView/Find-diff-between-month-to-month-Expense/m-p/121057#M752284 sunny_talwar 2018-10-19T14:14:50Z