topic Conditional set analysis in QlikView https://community.qlik.com/t5/QlikView/Conditional-set-analysis/m-p/658640#M1076067 <HTML><HEAD></HEAD><BODY><P>Hi, per the screenshot below, I wanted to calculate a compounded growth rate for 3 years based on quarters. Let's say user selects Qtr 20131 all the way to 20143. the formula that i use is</P><P></P><P>=pow(sum({$} Total_Sales)/Sum({$&lt;QuarterID = {"&gt;=$(=Min(QuarterID) - 12)&lt;=$(=Max(QuarterID) - 12)"}, Fiscal_Year =, Fiscal_Qtr = &gt;} Total_Sales),(1/3))-1</P><P></P><P>however, it is only calculating it by quarter for example for 20143, it is taking ((1,000 / 0)^(1/3))-1 which gives me error. and so on... What i wanted is to take current sales for the quarter selected by user and compare that to sales at 12 quarters back (in QuarterID) to get the answer.</P><P></P><P>is this doable? Can someone help please?</P><P></P><P>thanks!</P><P></P><P><IMG alt="" class="jiveImage" src="https://community.qlik.com/legacyfs/online/63192_pastedImage_1.png" style="width: 620px; height: 247px;" /></P></BODY></HTML> Sat, 26 Jul 2014 20:34:30 GMT Anonymous 2014-07-26T20:34:30Z Conditional set analysis https://community.qlik.com/t5/QlikView/Conditional-set-analysis/m-p/658640#M1076067 <HTML><HEAD></HEAD><BODY><P>Hi, per the screenshot below, I wanted to calculate a compounded growth rate for 3 years based on quarters. Let's say user selects Qtr 20131 all the way to 20143. the formula that i use is</P><P></P><P>=pow(sum({$} Total_Sales)/Sum({$&lt;QuarterID = {"&gt;=$(=Min(QuarterID) - 12)&lt;=$(=Max(QuarterID) - 12)"}, Fiscal_Year =, Fiscal_Qtr = &gt;} Total_Sales),(1/3))-1</P><P></P><P>however, it is only calculating it by quarter for example for 20143, it is taking ((1,000 / 0)^(1/3))-1 which gives me error. and so on... What i wanted is to take current sales for the quarter selected by user and compare that to sales at 12 quarters back (in QuarterID) to get the answer.</P><P></P><P>is this doable? Can someone help please?</P><P></P><P>thanks!</P><P></P><P><IMG alt="" class="jiveImage" src="https://community.qlik.com/legacyfs/online/63192_pastedImage_1.png" style="width: 620px; height: 247px;" /></P></BODY></HTML> Sat, 26 Jul 2014 20:34:30 GMT https://community.qlik.com/t5/QlikView/Conditional-set-analysis/m-p/658640#M1076067 Anonymous 2014-07-26T20:34:30Z