Datepicker doesn't select the range

[Anonymous]

Hello qlikers 🙂 ,

my date format looks like this: MM/YYYY for example -> NOV/2019.

For example I want to pick the range from JAN/2018 until NOV/2019. However the datepicker select only the first date. 

  and not the range. 

The date picker thinks also that the NOV/2019 is the 01.11.2019 -> so you can select only the first date of the month. 

Question: How can I select the range from JAN/2018 until NOV/2019 ? And when I click the date picker it should open the current month. Not the first. How can I do this? 

Thank you in advance! 🙂

[y_grynechko]

The thing is that the data range picker is build to work with full dates, not only with the month-year.

You can generate the dates in the load script between all of the month you have(just a standartd master calendar) and use it for the data range picker. Other than that you would need re-design the way picker was build. 

[Lech_Miszkiewicz · Accepted solution]

....The date picker thinks also that the NOV/2019 is the 01.11.2019 -> so you can select only the first date of the month. ....

Your date picker is probably right as your MMM/YYYY  field is likely created by using Date( MonthStart(YourDateField),'MMM/YYYY') which means that actual value is 1st day of each month with the month year mask format.

You can learn more about duality of data here:

https://qlikviewcookbook.com/2017/03/dual-storage-vs-dual-behavior/

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Scripting/Forma...