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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Summing Multiple months using slider & set analysis

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,

1 Reply
Not applicable
Author

Hi,

I hope the below will help you;

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

regards

Rajesh