how to show the rolling trend for the last six months in set analysis code

[Qlikuser09]

Is the way i can get the show the value of rolling trend for the last six months in set analysis code in KPI

[Chanty4u]

Try this s

RangeSum(Above(Sum(Sales), 0, 6))

[stevedark]

Hi @Qlikuser09 

Take a look at this blog post, it has an example for comparing a rolling 12 month period with the prior 12, it's just a case of tweaking the numbers to get a rolling 6 month period instead:

https://www.quickintelligence.co.uk/compare-rolling-twelve-month-period-in-qlik/

Hope that helps,

Steve