topic Dynamic Rate calculation in Last 12 month expression in QlikView https://community.qlik.com/t5/QlikView/Dynamic-Rate-calculation-in-Last-12-month-expression/m-p/133253#M20002 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>We have a dynamic rate populated from a table as mentioned in the excel </P><P></P><P>The LTM logic is as mentioned below :</P><P></P><P>Sum({$&lt; intYearMonth,Year,Month,intYearMonth={'&gt;$(=(Max(intYearMonth)-100))&nbsp; &lt;=$(=(Max(intYearMonth)))'}&gt;} Sales)</P><P></P><P>Please guide me with a solution on how we can bifurcate the rate if the year changes:</P><P></P><P>viz- if the max Intyearmonth is 201807 then the last 12 month calculation will go to 201708, but the rate of 2018 is different from that of 2017</P><P></P><P>attached is the data in excel fort reference </P></BODY></HTML> Thu, 12 Jul 2018 05:32:13 GMT aniketsr 2018-07-12T05:32:13Z Dynamic Rate calculation in Last 12 month expression https://community.qlik.com/t5/QlikView/Dynamic-Rate-calculation-in-Last-12-month-expression/m-p/133253#M20002 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>We have a dynamic rate populated from a table as mentioned in the excel </P><P></P><P>The LTM logic is as mentioned below :</P><P></P><P>Sum({$&lt; intYearMonth,Year,Month,intYearMonth={'&gt;$(=(Max(intYearMonth)-100))&nbsp; &lt;=$(=(Max(intYearMonth)))'}&gt;} Sales)</P><P></P><P>Please guide me with a solution on how we can bifurcate the rate if the year changes:</P><P></P><P>viz- if the max Intyearmonth is 201807 then the last 12 month calculation will go to 201708, but the rate of 2018 is different from that of 2017</P><P></P><P>attached is the data in excel fort reference </P></BODY></HTML> Thu, 12 Jul 2018 05:32:13 GMT https://community.qlik.com/t5/QlikView/Dynamic-Rate-calculation-in-Last-12-month-expression/m-p/133253#M20002 aniketsr 2018-07-12T05:32:13Z