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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
jglenn87
Contributor
Contributor
‎2020-02-27 12:01 PM

Expression for all dates less than 'TODAY'

Hello,

 

I am trying to create a button for a sheet to filter for all dates less than TODAY using the 'TODAY' Expression, but have not been successful so far. Any ideas?

1,292 Views
1 Reply
TimvB
Creator II
Creator II
‎2020-02-28 10:42 AM

You can add a flag field to your mastercalendar in the script that flags all dates that are earlier than today, today and in the future, for example:

If(DateField < Today(), 'Past', If(DateField = Today(), 'Today', 'Future')) as DateSortFlag

Add a filter object with the dimension field DateSortFlag to the sheet and users are able to select dates from the past in one click.

Hope it helps!

 

1,247 Views
0 Likes