Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
Isgranda
Contributor
Contributor

How to exclude current calendar month from a field filter pane?

On my filter pane, I want to show all the months except the current calendar month. In the below example, I want to omit the month of June 2020 and when we are in July, I want to exclude July and so and so forth. 

I want the user to be able to filter on all the older months. This filter is linked to a data table and it goes back to April 2019. 

I need to exclude the current month from my month filter pane? Is there a way to this? 

 

Isgranda_0-1591308350801.png

 

 

 

Labels (2)
4 Replies
Lisa_P
Employee
Employee

You can create a calculated field for this purpose.

Rather than using the field Month, in the filter pane use an expression like:

=Aggr(Only({<Month=-{'$(=Month(Today()))'}>}Month), Month)

Isgranda
Contributor
Contributor
Author

@Lisa  - It does not work.

Isgranda_0-1592580566147.png

Isgranda_1-1592580611595.png

 

 

 

Isgranda
Contributor
Contributor
Author

Please help 

Lisa_P
Employee
Employee

I do not know your data. You don't appear to have a field called Month.