Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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?

2 Replies
pover
Luminary Alumni
Luminary Alumni

Create a monthyear field with the funtion MonthName in the script than try something like the expression below:

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

Regards.

Not applicable
Author

sorry but it is wrong!

I can not insert my file.qvw in Network