Summing Multiple months using slider & set analysis

Tue, 27 Apr 2010 16:14:34 GMT

if((sum({$<Month={SliderMonth}>}total [Sales Amount]) - sum({$<Month={MonthPlusOneCustomerAddDate}>}Total [Sales Amount])) / sum({$<Month={SliderMonth}>}total [Sales Amount]) >= SliderGrowthPercentage, sum([Sales Amount]))

What i want to do is change this logic to sum(MonthPlusOneCustomerAddDate) / sum(All months from slider to inception date)

So if the add date is january, and the slider is on april then the equation is as follows

sum(january) / sum(Jan-April)

Any thoughts?

Thanks,

Summing Multiple months using slider & set analysis

Wed, 28 Apr 2010 06:36:56 GMT

Hi,

I hope the below will help you;

Sum( {$<Month={'=$(addmonth)'}>} amount ) / sum( {$<Month={'>=$(addmonth) <=$(slidermonth)'}>} amount )

regards

Rajesh

topic Summing Multiple months using slider & set analysis in QlikView

Summing Multiple months using slider & set analysis

Summing Multiple months using slider & set analysis