Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Learn how to migrate to Qlik Cloud Analytics™: On-Demand Briefing!
cancel
Showing results for 
Search instead for 
Did you mean: 
realpixel
Creator
Creator

Calendar question selection

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?

1 Solution

Accepted Solutions
hic
Former Employee
Former Employee

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.

Date search.png

HIC

View solution in original post

4 Replies
jonathandienst
Partner - Champion III
Partner - Champion III

Hi

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
hic
Former Employee
Former Employee

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.

Date search.png

HIC

realpixel
Creator
Creator
Author

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

realpixel
Creator
Creator
Author

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.