topic Re: Calendar question selection in QlikView

Calendar question selection

realpixel — Thu, 12 Dec 2013 09:53:37 GMT

Hello,

I have a calendar by years, month and days, see attached document.

But I need to this selection.

All month from January to november with all days (01 to 31) + the last month (december) only a selection by day for example from the first (01) to 09.

From my calendar see attached document, if I done the selection describe above the result is all month january to decembrer with only days 01 to 09 for each month.

Someone have an idea?

Re: Calendar question selection

jonathandienst — Thu, 12 Dec 2013 10:02:13 GMT

I think you will need to allow the users to select a date, not just the day of the month, as well. So they could select the month December, so that the days for December are visible in that date selection. The user should then select the December days required, de-select December from the month selection and then select the months required before December.

Or start typing in the date field: <='2013/12/11'

HTH

Jonathan

Re: Calendar question selection

hic — Thu, 12 Dec 2013 10:03:18 GMT

You cannot make a selection in all three fields, because this will be evaluated as an AND between the fields. So, when you select the Day to be between 1 and 9, you effectively do this for all months.

Instead you should make the selection in the date field directly, see picture.

HIC

Re: Calendar question selection

realpixel — Thu, 12 Dec 2013 10:33:09 GMT

Thank you for you answer.

I try with <=09-12-2013 or >=01-01-2013<=09-12-2013 from a list box it's return all date.

I have second question in the case of selection by date return a correct value, how to select all value contains between the selection >=01-01-2013<=09-12-2013 in one shot

Re: Calendar question selection

realpixel — Thu, 12 Dec 2013 11:09:59 GMT

Sorry, I have done mistake during the selection due to the format of date DD/MM/YYYY.

With this selection >=01/01/2013<=09/12/2013 it's wotking fine

Thank you for your assistance.