topic Filter by difference between two dates in QlikView https://community.qlik.com/t5/QlikView/Filter-by-difference-between-two-dates/m-p/784261#M1031211 <HTML><HEAD></HEAD><BODY><P>I am new to QV and this is what I need to be able to do.</P><P></P><P>The user wants to be able to filter based on the following criteria:</P><P></P><P>Measure is currently due (today and 24 months prior to today)</P><P>Measure is due in 1 - 3 months from today</P><P>Measure is due in 4 - 6 months from today</P><P>Measure is due in 7 or more months from today</P><P></P><P>This would be based on the difference between the reporting period (MMYYYY) and the due date(MM/DD/YYYY).</P><P></P><P>Right now I have the due date calculated as a dimension based on some complex logic.</P><P></P><P>Any guidance would be greatly appreciated.</P></BODY></HTML> Thu, 29 Jan 2015 01:04:34 GMT rittermd 2015-01-29T01:04:34Z Filter by difference between two dates https://community.qlik.com/t5/QlikView/Filter-by-difference-between-two-dates/m-p/784261#M1031211 <HTML><HEAD></HEAD><BODY><P>I am new to QV and this is what I need to be able to do.</P><P></P><P>The user wants to be able to filter based on the following criteria:</P><P></P><P>Measure is currently due (today and 24 months prior to today)</P><P>Measure is due in 1 - 3 months from today</P><P>Measure is due in 4 - 6 months from today</P><P>Measure is due in 7 or more months from today</P><P></P><P>This would be based on the difference between the reporting period (MMYYYY) and the due date(MM/DD/YYYY).</P><P></P><P>Right now I have the due date calculated as a dimension based on some complex logic.</P><P></P><P>Any guidance would be greatly appreciated.</P></BODY></HTML> Thu, 29 Jan 2015 01:04:34 GMT https://community.qlik.com/t5/QlikView/Filter-by-difference-between-two-dates/m-p/784261#M1031211 rittermd 2015-01-29T01:04:34Z