topic Re: Date Range Picker "No data available for the range selected" in Integration, Extension & APIs

Date Range Picker "No data available for the range selected"

LuisNTT — Thu, 25 May 2023 09:44:13 GMT

I have a master calendar table with the entire date range, but when I try to select a date range, I get the message "No data available for the selected range".

After some digging it looks like date format issue, but tried all possible combinations and it still doesn't filter correctly the dates you selected.
Attached screenshot in case it helps.

Can somebody help me?

Thank you

Re: Date Range Picker "No data available for the range selected"

md_talib — Thu, 25 May 2023 10:14:24 GMT

Your master calendar is linked or unlinked ? and if it is possible please share the expression.

Re: Date Range Picker "No data available for the range selected"

Hania — Thu, 25 May 2023 10:48:03 GMT

is it possible for you to share your master calendar scrip ?

it might be possible that your dates are no generated .

Re: Date Range Picker "No data available for the range selected"

LuisNTT — Thu, 25 May 2023 12:12:57 GMT

Thanks for the responses, I'll try to answer both of them:

The master calendar table is linked to the table that I require to filter the data on.
The expression is: date(CalendarDate,'D/M/YYYY').

The script is:

MinMaxDate: load Min(StartDateScheduleSubject) as MinDate, mAX(GR_EndDateScheduleSubject) as MaxDate resident TSubjectsDatesAddendums; Let vMinDate = peek('MinDate',-1,'MinMaxDate') -1 ; Let vMaxDate = peek('MaxDate',-1,'MinMaxDate') ; DropTables MinMaxDate ; dates: Load *, Year(Date) & '/' & Month(Date) as monthyear, Year(Date) as Year, Month(Date) as Month; // Day(Date) as Day; Load Date($(vMinDate) + recno()) as Date autogenerate $(vMaxDate) - $(vMinDate) ;

Re: Date Range Picker "No data available for the range selected"

Hania — Fri, 26 May 2023 05:45:43 GMT

As your script working properly just do the slightly changes in line no: 8. add space between drop table.

I think you need to check your base data that you're getting.

hope this helpful.

Re: Date Range Picker "No data available for the range selected"

MacB — Thu, 07 Sep 2023 15:26:43 GMT

There is a limit of 10000 dates in Date Picker.

https://community.qlik.com/t5/Official-Support-Articles/Date-Picker-Extension-not-able-to-filter-date-range-of-28-years/ta-p/1818596

Maciek