topic Re: Calendar for table with two dates in QlikView https://community.qlik.com/t5/QlikView/Calendar-for-table-with-two-dates/m-p/1295637#M514571 <HTML><HEAD></HEAD><BODY><P>I think this is exactly what I needed, thank you!</P></BODY></HTML> Wed, 26 Jul 2017 14:45:21 GMT 2017-07-26T14:45:21Z Calendar for table with two dates https://community.qlik.com/t5/QlikView/Calendar-for-table-with-two-dates/m-p/1295635#M514569 <HTML><HEAD></HEAD><BODY><P>I have a feeling I'm missing something obvious here, so I'm hoping one of you can help me out:</P><P></P><P>I have a table with the following fields: </P><UL><LI>Notice</LI><LI>Concern</LI><LI>Opened_Date</LI><LI>Closed_Date</LI></UL><P></P><P>My end goal is to create a chart with a dimension of days (every day in the calendar, starting from the earliest Opened_Date), and two expressions: 1) The Count of Notices that were opened on the day in question, and 2) The Count of Notices that were closed on the day in question. </P><P></P><P>I'm not sure how to create a calendar that will connect to the existing table, and let me check if Opened_Date = [Whatever Date Field is Called] and Closed_Date = <SPAN style="font-size: 13.3333px;"> [Whatever Date Field is Called].</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Any thoughts? Thanks in advance! </SPAN></P></BODY></HTML> Wed, 26 Jul 2017 13:28:43 GMT https://community.qlik.com/t5/QlikView/Calendar-for-table-with-two-dates/m-p/1295635#M514569 2017-07-26T13:28:43Z Re: Calendar for table with two dates https://community.qlik.com/t5/QlikView/Calendar-for-table-with-two-dates/m-p/1295636#M514570 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>May be this help you <A href="https://community.qlik.com/qlik-blogpost/3585">Canonical Date</A></P></BODY></HTML> Wed, 26 Jul 2017 13:38:17 GMT https://community.qlik.com/t5/QlikView/Calendar-for-table-with-two-dates/m-p/1295636#M514570 ahaahaaha 2017-07-26T13:38:17Z Re: Calendar for table with two dates https://community.qlik.com/t5/QlikView/Calendar-for-table-with-two-dates/m-p/1295637#M514571 <HTML><HEAD></HEAD><BODY><P>I think this is exactly what I needed, thank you!</P></BODY></HTML> Wed, 26 Jul 2017 14:45:21 GMT https://community.qlik.com/t5/QlikView/Calendar-for-table-with-two-dates/m-p/1295637#M514571 2017-07-26T14:45:21Z