Qlik Community

QlikView Integrations

Discussion Board for collaboration on QlikView Integration.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
suryakiran
Contributor
Contributor

Set Analysis For Rolling periods in a dimension

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.

dual.PNG

Thank you in Advance!

-Suryakiran

1 Reply
sunny_talwar

May be like this

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