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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Selecting prior and future dates with buttons

I have imported a field [Meeting Date] which has prior year and future six months data.  I want to use a button or other appropriate method to set the dates shown as either all the dates prior to today or all the dates in the future.   I am using the Field [Meeting Date] in the Action Select in Field.  I haven't found a way to get the Search String to return the results I am looking for. I can return = Today(),(one date, naturally) but using <= Today() isn't working.   I'm very new to QlikView, but have done similar things with other BI tools.  I apparently don't understand the way the tool works with scripts.  I have seen examples such as ='<=' Today(), but that doesn't return any results and gives me formatting warnings.

1 Reply
Not applicable
Author

No sooner did I ask than I found the answer.  Building the search string returns the prior dates as needed.  ='<='&Today()