topic Master calendar and selectable null dates? in QlikView https://community.qlik.com/t5/QlikView/Master-calendar-and-selectable-null-dates/m-p/528134#M693698 <HTML><HEAD></HEAD><BODY><P>I have a table with 2 dates; OpenDate and CloseDate.</P><P></P><P>A null CloseDate means the record has not been closed yet.&nbsp; I replace nulls with "Open" in the script.</P><P></P><P>I want Year, Month, and Day selection listboxes for CloseDate, with the ability to select "Open" if CloseDate is Null.</P><P></P><P>If I replace null CloseDates with 'Open' and join to a master calendar, I will get greyed out list boxes due to missing records since 'Open' is not a value in the master calendar.</P><P>If I create CloseDate_Year, CloseDate__Month, and CloseDate_Day within the table, then the listboxes may not contain every individual day.</P><P></P><P>Is there any way to get both every date, and selectable Open CloseDates?</P></BODY></HTML> Mon, 01 Jul 2013 20:51:46 GMT 2013-07-01T20:51:46Z Master calendar and selectable null dates? https://community.qlik.com/t5/QlikView/Master-calendar-and-selectable-null-dates/m-p/528134#M693698 <HTML><HEAD></HEAD><BODY><P>I have a table with 2 dates; OpenDate and CloseDate.</P><P></P><P>A null CloseDate means the record has not been closed yet.&nbsp; I replace nulls with "Open" in the script.</P><P></P><P>I want Year, Month, and Day selection listboxes for CloseDate, with the ability to select "Open" if CloseDate is Null.</P><P></P><P>If I replace null CloseDates with 'Open' and join to a master calendar, I will get greyed out list boxes due to missing records since 'Open' is not a value in the master calendar.</P><P>If I create CloseDate_Year, CloseDate__Month, and CloseDate_Day within the table, then the listboxes may not contain every individual day.</P><P></P><P>Is there any way to get both every date, and selectable Open CloseDates?</P></BODY></HTML> Mon, 01 Jul 2013 20:51:46 GMT https://community.qlik.com/t5/QlikView/Master-calendar-and-selectable-null-dates/m-p/528134#M693698 2013-07-01T20:51:46Z Re: Master calendar and selectable null dates? https://community.qlik.com/t5/QlikView/Master-calendar-and-selectable-null-dates/m-p/528135#M693699 <HTML><HEAD></HEAD><BODY><P>You can either add a dummy value to your master calendar to link it with the Open value from the CloseDate field or add a listbox for CloseDate and select Open in that listbox.</P></BODY></HTML> Tue, 02 Jul 2013 18:25:48 GMT https://community.qlik.com/t5/QlikView/Master-calendar-and-selectable-null-dates/m-p/528135#M693699 Gysbert_Wassenaar 2013-07-02T18:25:48Z