topic Re: How do I create a calendar (x2) for minimum and maximum date range based on a single value? in QlikView

How do I create a calendar (x2) for minimum and maximum date range based on a single value?

Wed, 14 Nov 2012 11:46:50 GMT

Hello, I am writing a report where I want to restrict data by date range in the form of a calendar x 2, one for minimum range and one for maximum range.

Thanks.

Paul.

Re: How do I create a calendar (x2) for minimum and maximum date range based on a single value?

Gysbert_Wassenaar — Wed, 14 Nov 2012 12:13:16 GMT

Have you tried using a slider object with Mode set to multi value for the date range?

Re: How do I create a calendar (x2) for minimum and maximum date range based on a single value?

Wed, 14 Nov 2012 12:15:28 GMT

I don't want a date slider as they don't represent the data in a way in which I want which is in 'Calendar' format.

Paul

Re: How do I create a calendar (x2) for minimum and maximum date range based on a single value?

Wed, 14 Nov 2012 12:49:39 GMT

Hi,

You could use two calendar objects - one for start date and one for end date. This way you will be able to select a date range to filter data for the selected dates.

Is that what you are looking for?

Regards,

-Khaled.

Re: How do I create a calendar (x2) for minimum and maximum date range based on a single value?

Wed, 14 Nov 2012 13:03:12 GMT

This doesnt work as its based up a single value in the script.

Re: How do I create a calendar (x2) for minimum and maximum date range based on a single value?

Gysbert_Wassenaar — Wed, 14 Nov 2012 13:03:28 GMT

Ok, see attached example.

Re: How do I create a calendar (x2) for minimum and maximum date range based on a single value?

Wed, 14 Nov 2012 13:14:16 GMT

Thanks for that, in the tab min date and max date you under variable(s) have set vmindate and vmax date, I don't have that option to chose as a variable, how do I get this?

Paul.

Re: How do I create a calendar (x2) for minimum and maximum date range based on a single value?

Wed, 14 Nov 2012 13:21:55 GMT

Hi,

You can do this with a single date field.

Please check the attachment.

Hope that helps.

Regards,

-Khaled

Re: How do I create a calendar (x2) for minimum and maximum date range based on a single value?

Wed, 14 Nov 2012 13:29:03 GMT

What version of Qlikview are you using, I dont have access to variable 'vEndDate' in the variables drop down. I am using version 10.

Re: How do I create a calendar (x2) for minimum and maximum date range based on a single value?

Thu, 15 Nov 2012 17:35:45 GMT

Hi,

I am using QlikView version 11. But I'm not sure if Ctrl+Alt+V combinations will work in QV 10.

Please check the attachment.

Hope that helps.

Regards,

-Khaled.

Re: How do I create a calendar (x2) for minimum and maximum date range based on a single value?

Anonymous — Thu, 29 Nov 2012 19:23:46 GMT

Hi Khaled,

Very helpfull and thourough application.

I think it was important to point out the action that is needed once you select both Start and End Date

='>=' & Date(vStartDate, 'M/D/YYYY') & '<=' & Date(vEndDate, 'M/D/YYYY')

Gysbert had omitted to mention the triggers used in his app It took a minute to understand how the selection was being made.

Cheers,

Benoit

Re: How do I create a calendar (x2) for minimum and maximum date range based on a single value?

Anonymous — Thu, 29 Nov 2012 23:49:03 GMT

Hi Benoit,

I was scratching my head on that one. Knew there had to be something to tell it greater/less.

Now, my question is, where is that added?

Thanks

Re: How do I create a calendar (x2) for minimum and maximum date range based on a single value?

Anonymous — Fri, 30 Nov 2012 14:54:03 GMT

Hi Darrin,

In Gysbert's example SalesToDate12, you have to add the triggers to the variables.

Settings > Document Properties > Triggers/Variables Event Triggers.

You should have listed the 2 variables you created for the 2 input calendars - in his case vMaxDate and vMinDate.

Add the actions OnInput. Select In Field on your Date field.

='>='&Date(vMinDate)&'<='&Date(vMaxDate)

That is essentialy what Khaled is doing in his example; he just uses an button/action to do so.

Cheers,