topic Re: Date range picker: Display date less than or equal to the selected date in App Development

Date range picker: Display date less than or equal to the selected date

jmialoundama — Sat, 16 Nov 2024 19:01:39 GMT

I am using the Qlik Sense Date Range Picker extension.

I decided to use only the "Single Date" option because my goal is to leave the choice to the user to select a date and that in my table the date less than or equal to the date selected in the date range picker displayed.

Example: If the user selects 24/01/2020 in the Date Range Picker, then the dates from 01/01/2020 to 240/01/2020 should be displayed.
That is to say all the dates before or equal to 24/01/2020 must appear in my table.

Knowing that in my measure I do this:

sum({$< Flag_Fait={'F_TAXES'},[DATE FOR GL]={"<=$(=max([DATE FOR GL]))"},YEAR=>}[AMOUNT GROSS])

However when I select a date in the calendar I only have the selected date displayed and not the lower dates.

Re: Date range picker: Display date less than or equal to the selected date

AndrewHughes — Thu, 27 Feb 2020 17:47:50 GMT

It sounds like you would like to select one date 24/01/2020 and return all dates to the beginning of the year. You probably want to do set analysis like this https://community.qlik.com/t5/QlikView-App-Development/Set-analysis-Filter-for-all-dates-prior-to-current-date/td-p/1136988. You can also add a YTD (year-to-date) field to your calendar and use it in your selection box.

Re: Date range picker: Display date less than or equal to the selected date

jmialoundama — Fri, 28 Feb 2020 08:30:00 GMT

Thank you for your reply.

However, I looked at the repost that you put in and the formula that is used is the same as mine.

In fact I explain myself a little better. My formula works when I use the "filter pane" object, however this formula does not work when I use the "Date range picker" object