Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2014-07-26 04:34 PM

Conditional set analysis

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

=pow(sum({$} Total_Sales)/Sum({$<QuarterID = {">=$(=Min(QuarterID) - 12)<=$(=Max(QuarterID) - 12)"}, Fiscal_Year =, Fiscal_Qtr = >} Total_Sales),(1/3))-1

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.

is this doable? Can someone help please?

thanks!

241 Views
0 Likes
0 Replies