Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
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],';')

View solution in original post

MCmiranda
Contributor II
Contributor II
Author

Woww  😍  Thaknk you