Button Object - Select a range of dates in field

blaise — Sat, 16 Nov 2024 18:32:54 GMT

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-button/m-p/1539178#M40179 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?

Re: Button Object - Select a range of dates in field

blaise — Wed, 03 Jun 2020 12:07:00 GMT

Solved with the concat function;

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

topic Re: Button Object - Select a range of dates in field in App Development

Button Object - Select a range of dates in field

Re: Button Object - Select a range of dates in field