Set Analysis For Rolling periods in a dimension

Anonymous — Mon, 26 Jan 2026 16:26:21 GMT

Hi All,

I am struck with the below Problem.

Actually, When I select for a value(for suppose 2018Q1) I need to display only 4 trailing periods in the chart for that corresponding "YearQuarter" value. Means only 4 previous rows(2017Q1,2017Q2,2017Q3 and 2017Q4).

Dynamic Filtering here I need.

I have tried dual function(YOY) to filter the values, but couldn't achieve it.

Thank you in Advance!

-Suryakiran

Re: Set Analysis For Rolling periods in a dimension

sunny_talwar — Fri, 23 Feb 2018 17:39:31 GMT

May be like this

Sum({<YearQuarter, YoY, Year, Date1 = {"$(='>' & Date(AddYears(Max(Date1), -1), 'D/M/YYYY') & '<=' & Date(Max(Date1), 'D/M/YYYY'))"}>} Salary)

topic Set Analysis For Rolling periods in a dimension in QlikView

Set Analysis For Rolling periods in a dimension

Re: Set Analysis For Rolling periods in a dimension