topic Re: Calculate evolution from one month to another in QlikView https://community.qlik.com/t5/QlikView/Calculate-evolution-from-one-month-to-another/m-p/93232#M766185 <HTML><HEAD></HEAD><BODY><P>What kind of chart are you using? Is it a pivot table or straight table? Are you using MonthYear or Month as one of your dimension? If you are... you need to use <A href="https://community.qlik.com/docs/DOC-14624">Inter-Record Functions</A> such as Above/Below for Straight table or After/Before for pivot table where Month or MonthYear is a pivoted dimension. You can also use <A href="https://community.qlik.com/qlik-blogpost/4531">The As-Of Table</A> which need some script modifications.</P><P></P><P>If Month or MonthYear is not a dimension, then you can use set analysis to do this</P></BODY></HTML> Tue, 17 Jul 2018 15:47:50 GMT sunny_talwar 2018-07-17T15:47:50Z Calculate evolution from one month to another https://community.qlik.com/t5/QlikView/Calculate-evolution-from-one-month-to-another/m-p/93231#M766184 <HTML><HEAD></HEAD><BODY><P>Hello everyone <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" />&nbsp; I have a database with the number of total sales for each month, for year 2018. How can I calculate the evolution from one month to another in percentage (example: from May to June is a growth with 3.2%). Thank you very much!</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Calculate-evolution-from-one-month-to-another/m-p/93231#M766184 Anonymous 2020-11-25T16:16:04Z Re: Calculate evolution from one month to another https://community.qlik.com/t5/QlikView/Calculate-evolution-from-one-month-to-another/m-p/93232#M766185 <HTML><HEAD></HEAD><BODY><P>What kind of chart are you using? Is it a pivot table or straight table? Are you using MonthYear or Month as one of your dimension? If you are... you need to use <A href="https://community.qlik.com/docs/DOC-14624">Inter-Record Functions</A> such as Above/Below for Straight table or After/Before for pivot table where Month or MonthYear is a pivoted dimension. You can also use <A href="https://community.qlik.com/qlik-blogpost/4531">The As-Of Table</A> which need some script modifications.</P><P></P><P>If Month or MonthYear is not a dimension, then you can use set analysis to do this</P></BODY></HTML> Tue, 17 Jul 2018 15:47:50 GMT https://community.qlik.com/t5/QlikView/Calculate-evolution-from-one-month-to-another/m-p/93232#M766185 sunny_talwar 2018-07-17T15:47:50Z