topic Re: Create To and From Calendar in QlikView in QlikView

Create To and From Calendar in QlikView

Ahmed_Turnaround — Thu, 05 Sep 2019 11:00:18 GMT

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!

Re: Create To and From Calendar in QlikView

wade12 — Fri, 06 Sep 2019 12:25:59 GMT

have you tried using a slider?

Re: Create To and From Calendar in QlikView

Ahmed_Turnaround — Mon, 09 Sep 2019 10:58:57 GMT

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?

Re: Create To and From Calendar in QlikView

Ahmed_Turnaround — Tue, 10 Sep 2019 09:39:13 GMT

Any help please?

Re: Create To and From Calendar in QlikView

Or — Tue, 10 Sep 2019 10:11:16 GMT

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-Date/ta-p/1478524

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.

Re: Create To and From Calendar in QlikView

Brett_Bleess — Wed, 18 Sep 2019 15:11:10 GMT

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