Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
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?

Labels (1)
0 Replies