topic Calendar for several dates in QlikView https://community.qlik.com/t5/QlikView/Calendar-for-several-dates/m-p/972108#M332679 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I created a QV application regarding some support cases from salesforce. And I have to create a report about remaining cases per month. But this formula is taking the remaining cases from the previous month + opened cases from current month - closed cases from current month.</P><P></P><P>Each case's status is determined by its date. For example, a Case is closed if has 'ClosedDate', if the 'ClosedDate' is empty means that the case is not closed. </P><P>The same thing is with Open status. If a Case has OpenDate means that the Case was opened.</P><P>And there is a third date which is 'CreatedDate', this date is important because it helps me to figure out when each case was created.</P><P></P><P>My difficulty is that I've created a chart with 'OpenDate' as dimension, but my formulas contains the other dates too and is not 'compatible' <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" />.</P><P></P><P>How can I create a master calendar to link these 3 dates into one ? </P><P></P><P>Or if you have another idea how can I create this chart, please tell me.</P><P></P><P>Thanks,</P><P>Claudiu</P></BODY></HTML> Fri, 04 Sep 2015 07:33:13 GMT 2015-09-04T07:33:13Z Calendar for several dates https://community.qlik.com/t5/QlikView/Calendar-for-several-dates/m-p/972108#M332679 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I created a QV application regarding some support cases from salesforce. And I have to create a report about remaining cases per month. But this formula is taking the remaining cases from the previous month + opened cases from current month - closed cases from current month.</P><P></P><P>Each case's status is determined by its date. For example, a Case is closed if has 'ClosedDate', if the 'ClosedDate' is empty means that the case is not closed. </P><P>The same thing is with Open status. If a Case has OpenDate means that the Case was opened.</P><P>And there is a third date which is 'CreatedDate', this date is important because it helps me to figure out when each case was created.</P><P></P><P>My difficulty is that I've created a chart with 'OpenDate' as dimension, but my formulas contains the other dates too and is not 'compatible' <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" />.</P><P></P><P>How can I create a master calendar to link these 3 dates into one ? </P><P></P><P>Or if you have another idea how can I create this chart, please tell me.</P><P></P><P>Thanks,</P><P>Claudiu</P></BODY></HTML> Fri, 04 Sep 2015 07:33:13 GMT https://community.qlik.com/t5/QlikView/Calendar-for-several-dates/m-p/972108#M332679 2015-09-04T07:33:13Z Re: Calendar for several dates https://community.qlik.com/t5/QlikView/Calendar-for-several-dates/m-p/972109#M332680 <HTML><HEAD></HEAD><BODY><P>Look at Canonical Calendar: <A href="https://community.qlik.com/qlik-blogpost/3585">Canonical Date</A></P><P></P><P>HTH</P><P></P><P>Best,</P><P>Sunny</P></BODY></HTML> Fri, 04 Sep 2015 07:39:08 GMT https://community.qlik.com/t5/QlikView/Calendar-for-several-dates/m-p/972109#M332680 sunny_talwar 2015-09-04T07:39:08Z Re: Calendar for several dates https://community.qlik.com/t5/QlikView/Calendar-for-several-dates/m-p/972110#M332681 <HTML><HEAD></HEAD><BODY><P>Very very helpful. Thank you.</P></BODY></HTML> Fri, 04 Sep 2015 08:53:24 GMT https://community.qlik.com/t5/QlikView/Calendar-for-several-dates/m-p/972110#M332681 2015-09-04T08:53:24Z Re: Calendar for several dates https://community.qlik.com/t5/QlikView/Calendar-for-several-dates/m-p/972111#M332682 <HTML><HEAD></HEAD><BODY><P>Not a problem <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>I am glad I was able to guide you in the right direction.</P><P></P><P>Best,</P><P>Sunny</P></BODY></HTML> Fri, 04 Sep 2015 10:25:20 GMT https://community.qlik.com/t5/QlikView/Calendar-for-several-dates/m-p/972111#M332682 sunny_talwar 2015-09-04T10:25:20Z