Create To and From Calendar in QlikView

[Ahmed_Turnaround]

Hi,

In my QlikView Application, I had a field called [ITEM RELEASE DATE], is it possible to create a calender object that allows the user to select the start and from date?

Does anyone have a guide for this that can help me create this from scratch? I want the user to be able to select dates of interest and then see what items have been released within those dates. 

Thanks!

[wade12]

have you tried using a slider?

[Ahmed_Turnaround]

Hi,

Thanks for your reply. The slider doesn't give me the correct display and doesn't display the dates correctly. I'd like to use two calendar objects, one that has the minimum date and another with the maximum date. So when the user makes a selection on each object, it will show items that have been released within that date range.

How do I achieve that? 

[Ahmed_Turnaround]

Any help please? 

[Or]

The QlikView calendar object  as far as I know, does not support selecting to and from dates. Qlik Sense didn't even ship with a calendar object (though an extension is bundled in now). You can select a range of dates by dragging over that range, and you can select multiple ranges (or span multiple months) by holding CTRL on the keyboard. That's about it.

If you're willing to try your luck with an extension, there should be some out there that provide this functionality. A quick search turned up:

https://community.qlik.com/t5/QlikView-Documents/QlikView-Calendar-Extension-Object-For-Multi-Range-...

https://community.qlik.com/t5/QlikView-Scripting/Calendar-Extension/td-p/590892

But I couldn't tell you first-hand if these still work and match your use case. For the most part, people just wind up using preset periods (years, quarters, months, weeks) or selecting a smallish range of dates, which the calendar does support through drag-select.

[Brett_Bleess]

Have a look around the Design Blog area, here is a post that may help, not sure, but you can use the second link to search just the Design Blog area, as there are quite a few posts on date/calendar handling...

https://community.qlik.com/t5/Qlik-Design-Blog/Canonical-Date/ba-p/1463578

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett