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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
andre_bento
Contributor III
Contributor III

Filtering date for autocalendar

Good afternoon, 

I created a line chart to verify trends, seasonality and patterns and I am using as dimension Year.Month from autocalendar, I am trying to filter my date in order that only the values from January 2021 onward are plotted on it, I used the following expression "= {<[DATE.autoCalendar.YearMonth] = {"$(='>=2021-01')"}>} [DATE.autoCalendar.YearMonth]" but values prior to 2021-01 are still being shown. How can I update my set expression in order to achieve this?

Labels (2)
2 Replies
Clement15
Partner - Specialist
Partner - Specialist

Hello, does this work?

= only({<[DATE.autoCalendar.YearMonth] = {">=$(='2021-01')"}>} [DATE.autoCalendar.YearMonth])

 

andre_bento
Contributor III
Contributor III
Author

Negative.