topic Re: Comparing create and expiry dates in QlikView https://community.qlik.com/t5/QlikView/Comparing-create-and-expiry-dates/m-p/466586#M565191 <HTML><HEAD></HEAD><BODY><P>When you have two dates, one for creation and other for expiration, usually it is a good idea to use a Triangulation Report. This consists on using a Pivot Chart, and putting one date on columns and the other on rows, and your measure (number of contracts, for example) as your expression for the cells value.</P><P></P><P>Bellow you have an example of this type of report:</P><P><IMG __jive_id="32733" class="jive-image-thumbnail jive-image" height="193" onclick="" alt="Capture.PNG" src="https://community.qlik.com/legacyfs/online/32733_Capture.PNG" style="height: 193px; width: 620.3571428571429px;" width="620" /></P><P></P><P>JG</P></BODY></HTML> Tue, 29 Jan 2013 10:19:00 GMT 2013-01-29T10:19:00Z Comparing create and expiry dates https://community.qlik.com/t5/QlikView/Comparing-create-and-expiry-dates/m-p/466583#M565188 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P>I have 2 date fields one create date and expiry date....</P><P>I want to compare these two dates in the chart side by side with their counts for every year.</P><P>can any one please help me in doing this.</P></BODY></HTML> Tue, 29 Jan 2013 09:55:30 GMT https://community.qlik.com/t5/QlikView/Comparing-create-and-expiry-dates/m-p/466583#M565188 2013-01-29T09:55:30Z Re: Comparing create and expiry dates https://community.qlik.com/t5/QlikView/Comparing-create-and-expiry-dates/m-p/466584#M565189 <HTML><HEAD></HEAD><BODY><P>Could you provide an example of comparison? What Do you want to know, number of days, of months or what else?</P></BODY></HTML> Tue, 29 Jan 2013 09:58:57 GMT https://community.qlik.com/t5/QlikView/Comparing-create-and-expiry-dates/m-p/466584#M565189 alexandros17 2013-01-29T09:58:57Z Re: Comparing create and expiry dates https://community.qlik.com/t5/QlikView/Comparing-create-and-expiry-dates/m-p/466585#M565190 <HTML><HEAD></HEAD><BODY><P>Here is an example, hope it helps but I wait other informations.</P></BODY></HTML> Tue, 29 Jan 2013 10:02:56 GMT https://community.qlik.com/t5/QlikView/Comparing-create-and-expiry-dates/m-p/466585#M565190 alexandros17 2013-01-29T10:02:56Z Re: Comparing create and expiry dates https://community.qlik.com/t5/QlikView/Comparing-create-and-expiry-dates/m-p/466586#M565191 <HTML><HEAD></HEAD><BODY><P>When you have two dates, one for creation and other for expiration, usually it is a good idea to use a Triangulation Report. This consists on using a Pivot Chart, and putting one date on columns and the other on rows, and your measure (number of contracts, for example) as your expression for the cells value.</P><P></P><P>Bellow you have an example of this type of report:</P><P><IMG __jive_id="32733" class="jive-image-thumbnail jive-image" height="193" onclick="" alt="Capture.PNG" src="https://community.qlik.com/legacyfs/online/32733_Capture.PNG" style="height: 193px; width: 620.3571428571429px;" width="620" /></P><P></P><P>JG</P></BODY></HTML> Tue, 29 Jan 2013 10:19:00 GMT https://community.qlik.com/t5/QlikView/Comparing-create-and-expiry-dates/m-p/466586#M565191 2013-01-29T10:19:00Z