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: 
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 (1)
2 Replies
Clement15
Partner - Creator III
Partner - Creator III

Hello, does this work?

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

 

andre_bento
Contributor III
Contributor III
Author

Negative.