topic Derive Corresponding Quarter from Previous Year. in App Development https://community.qlik.com/t5/App-Development/Derive-Corresponding-Quarter-from-Previous-Year/m-p/1223123#M23794 <HTML><HEAD></HEAD><BODY><P>Hi Friends,</P><P></P><P>Plz help me how to calcullate the below metrix.</P><P>&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 470px;"><TBODY><TR><TD class="xl67" colspan="2" height="18" width="470">Metrics to be derived</TD></TR><TR><TD class="xl66" height="35" width="130">2017 -Q2 </TD><TD>MAX Quarter Always</TD></TR><TR><TD height="18">2016-Q2</TD><TD>Quarter Corresponding to Max Quarter of Previous Year</TD></TR><TR><TD class="xl66" height="18" width="130">2017-Q1</TD><TD>Max Quarter - 1</TD></TR><TR><TD height="18">Y/Y %</TD><TD>2017Q2-2016Q2/2016Q2</TD></TR><TR><TD height="18">Q/Q %</TD><TD>2017Q2-2017Q1/2017Q1</TD></TR></TBODY></TABLE><P></P><P>Attached the Excel Sheet.</P><P>It would be of great help if some one can give me some pointers to it.</P><P></P><P>Regards,</P><P>Ravi</P></BODY></HTML> Thu, 16 Mar 2017 14:42:36 GMT kishoreravi1983 2017-03-16T14:42:36Z Derive Corresponding Quarter from Previous Year. https://community.qlik.com/t5/App-Development/Derive-Corresponding-Quarter-from-Previous-Year/m-p/1223123#M23794 <HTML><HEAD></HEAD><BODY><P>Hi Friends,</P><P></P><P>Plz help me how to calcullate the below metrix.</P><P>&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 470px;"><TBODY><TR><TD class="xl67" colspan="2" height="18" width="470">Metrics to be derived</TD></TR><TR><TD class="xl66" height="35" width="130">2017 -Q2 </TD><TD>MAX Quarter Always</TD></TR><TR><TD height="18">2016-Q2</TD><TD>Quarter Corresponding to Max Quarter of Previous Year</TD></TR><TR><TD class="xl66" height="18" width="130">2017-Q1</TD><TD>Max Quarter - 1</TD></TR><TR><TD height="18">Y/Y %</TD><TD>2017Q2-2016Q2/2016Q2</TD></TR><TR><TD height="18">Q/Q %</TD><TD>2017Q2-2017Q1/2017Q1</TD></TR></TBODY></TABLE><P></P><P>Attached the Excel Sheet.</P><P>It would be of great help if some one can give me some pointers to it.</P><P></P><P>Regards,</P><P>Ravi</P></BODY></HTML> Thu, 16 Mar 2017 14:42:36 GMT https://community.qlik.com/t5/App-Development/Derive-Corresponding-Quarter-from-Previous-Year/m-p/1223123#M23794 kishoreravi1983 2017-03-16T14:42:36Z