Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
MCmiranda
Contributor II
Contributor II

This month selection not working

Hi all,

I want a button that filters on 'this month'. My column [Check Date] has date format dd/mm/yyyy

=Month(Today()) should work right?

It doesn't, at all, while I do have items in this month.

Anyone know what to do?

Labels (3)
1 Solution

Accepted Solutions
GaryGiles
Specialist
Specialist

=Concat({1<[Check Date]={">=$(=MonthStart(Today()))<=$(=MonthEnd(Today()))"}>} [Check Date],';')

View solution in original post

2 Replies
GaryGiles
Specialist
Specialist

=Concat({1<[Check Date]={">=$(=MonthStart(Today()))<=$(=MonthEnd(Today()))"}>} [Check Date],';')

MCmiranda
Contributor II
Contributor II
Author

Woww  😍  Thaknk you