Skip to main content
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 (2)
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), ';' )