Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is the way i can get the show the value of rolling trend for the last six months in set analysis code in KPI
Try this s
RangeSum(Above(Sum(Sales), 0, 6))
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