Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jmialoundama
Specialist
Specialist

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
AndrewHughes
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 https://community.qlik.com/t5/QlikView-App-Development/Set-analysis-Filter-for-all-dates-prior-to-cu.... You can also add a YTD (year-to-date) field to your calendar and use it in your selection box.
jmialoundama
Specialist
Specialist
Author

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