Qlik Community

App Development

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

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
jglenn87
Contributor
Contributor

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 Reply
TimvB
Creator II
Creator II

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!