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

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
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