Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set analisys rolling

I have to create a set that allows you to filter previous 12 months.

I wrote this expression but it is not correct.

expression1:

sum({$<year= {$(=max(year))}, month= {"<=$(=max({<year={$(=max(year))}>} month))>$(=max({<year={$(=max(year))}>} month)-12)"}>} QTA)

ES:
if I am in 2010-03 period i want set filters from 2010-03 to 2009-03

Can you help ,please?

0 Replies