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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
blaise
Partner - Specialist
Partner - Specialist

Button Object - Select a range of dates in field

Hi

Version: QS Desktop 2020 Apr

Im trying to use the button object (native) so select a range of dates in a date field. A single date (even an expression that returns a single date) works but not a range like >=2020-01-01<=2020-01-31 (that works perfectly fine when selecting this in the date field in a filter pane.

I have locked at the solution here - https://community.qlik.com/t5/Qlik-Sense-App-Development/Select-a-range-of-dates-using-a-Qlik-Sense-... where the use the (old) button for navigation from dashboard bundle extension. The difference seems to be that with the ext. object there is a possibility to "select value in field" but in native object I only have "select values in field" (note the s in values).

The following works f.ex. for my colleague in Feb2020 ext. bundle object;

='>=' & '$(=Today()-1)' & '<=' & '$(=Today()+1)'

but not in native object.

 

Anyone that got a solution or is this a WAD?

 

Labels (1)
1 Solution

Accepted Solutions
blaise
Partner - Specialist
Partner - Specialist
Author

Solved with the concat function;

=Concat({<Date= {">=$(=today()-3)<=$(=today())"}>} DISTINCT date(Date), ';' )

View solution in original post

1 Reply
blaise
Partner - Specialist
Partner - Specialist
Author

Solved with the concat function;

=Concat({<Date= {">=$(=today()-3)<=$(=today())"}>} DISTINCT date(Date), ';' )