Skip to main content
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
Showing results for 
Search instead for 
Did you mean: 

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

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.

2 Replies
Partner - Contributor III
Partner - Contributor III

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 You can also add a YTD (year-to-date) field to your calendar and use it in your selection box.

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