topic Re: Date Range using Calendar Object in QlikView

Date Range using Calendar Object

Mon, 26 Oct 2015 17:04:47 GMT

Hi,

I followed this link Build a Custom Date Range Selector and created a date range selection using input box and document triggers. It is working fine. However, I would like to have a calendar object for choosing the dates instead of picking the dates from the drop down of the input box. Is there a way to do this.

Thanks,

Sudha.

Re: Date Range using Calendar Object

Gysbert_Wassenaar — Mon, 26 Oct 2015 17:26:16 GMT

Perhaps this video tutorial helps: Selecting Arbitrary Date Ranges

Re: Date Range using Calendar Object

Tue, 27 Oct 2015 14:06:16 GMT

Hi,

Thank you. Watched the video and created the date range selection using the calendar object and document triggers and it is working fine. But, in my application, I have a couple of date ranges like create dt, resolved dt, update dt etc. When I try to extend the logic to other dates, it is not working. I made sure, I used different variable names but still, it doesn't work. Please let me know if I am missing anything.

Here the first From and To works but the second one does not.

This is the code I used:

Thanks,

Sudha.

Re: Date Range using Calendar Object

rubenmarin — Tue, 27 Oct 2015 14:08:47 GMT

Hi sudha, you have a typo in the second LET's, table name should be TEMP1

Re: Date Range using Calendar Object

Tue, 27 Oct 2015 14:14:00 GMT

Ya right. I corrected the mistake but still it does not work. Please take a look at the attached qvw.

Re: Date Range using Calendar Object

rubenmarin — Tue, 27 Oct 2015 14:20:21 GMT

Hi sudha, in document properties--> triggers --> variable events.

You should create actions for vStartDt and vEndDt like exist for vStartDate and vEndDate

Re: Date Range using Calendar Object

Tue, 27 Oct 2015 14:35:49 GMT

Thanks Marin. It's working fine.

Re: Date Range using Calendar Object

Fri, 30 Oct 2015 14:23:33 GMT

Hi,

I had to copy over the same logic in another QVW. Strangely, the same logic does not work. I have attached the qvw. Please go over the second tab 'ATT cases' and check what is missing in the 'Period Start Dt' and 'Period End Dt' logic

Re: Date Range using Calendar Object

rubenmarin — Mon, 02 Nov 2015 08:00:06 GMT

Hi sudha, seems something with date format, I tried this for end date:

='<=' & '$(=Date(vEndDate))'

Re: Date Range using Calendar Object

Tue, 03 Nov 2015 16:51:53 GMT

Thanks Ruben. It worked.