topic Re: Dynamic Date Comparison in QlikView https://community.qlik.com/t5/QlikView/Dynamic-Date-Comparison/m-p/304802#M495632 <HTML><HEAD></HEAD><BODY><P>Hi Hope this helps!</P><P></P><P>PFA</P></BODY></HTML> Wed, 25 Jan 2012 10:47:57 GMT 2012-01-25T10:47:57Z Dynamic Date Comparison https://community.qlik.com/t5/QlikView/Dynamic-Date-Comparison/m-p/304799#M495629 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I've set up a date selector that allows users to enter a <EM>to</EM> and <EM>from</EM> date for which data will be displayed. I would now like to make a comparison between the date range they've entered and the previous period relative to this date range. For instance, if they enter 12/20/2011 to 12/30/2011, I would like to show the figures for 12/9/2011 to 12/19/2011 in another column.</P><P></P><P>I've seen similar things done with the addmonths fuction, but have not been able to find a way to do it with days.</P><P></P><P>I've attached the example I'm working with. If anyone has any insight, it would be greatly appreciated.</P><P></P><P>Best,</P><P></P><P>Matt</P></BODY></HTML> Wed, 25 Jan 2012 09:54:02 GMT https://community.qlik.com/t5/QlikView/Dynamic-Date-Comparison/m-p/304799#M495629 2012-01-25T09:54:02Z Re: Dynamic Date Comparison https://community.qlik.com/t5/QlikView/Dynamic-Date-Comparison/m-p/304800#M495630 <HTML><HEAD></HEAD><BODY><P> hei check the attach example</P><P></P><P></P><P>i added a varaible of days diff </P><P>and used it in thep previous expression</P></BODY></HTML> Wed, 25 Jan 2012 10:13:13 GMT https://community.qlik.com/t5/QlikView/Dynamic-Date-Comparison/m-p/304800#M495630 lironbaram 2012-01-25T10:13:13Z Dynamic Date Comparison https://community.qlik.com/t5/QlikView/Dynamic-Date-Comparison/m-p/304801#M495631 <HTML><HEAD></HEAD><BODY><P>Hi Liron,</P><P></P><P>Thanks so much for the help, works perfectly!</P><P></P><P>Matt</P></BODY></HTML> Wed, 25 Jan 2012 10:43:19 GMT https://community.qlik.com/t5/QlikView/Dynamic-Date-Comparison/m-p/304801#M495631 2012-01-25T10:43:19Z Re: Dynamic Date Comparison https://community.qlik.com/t5/QlikView/Dynamic-Date-Comparison/m-p/304802#M495632 <HTML><HEAD></HEAD><BODY><P>Hi Hope this helps!</P><P></P><P>PFA</P></BODY></HTML> Wed, 25 Jan 2012 10:47:57 GMT https://community.qlik.com/t5/QlikView/Dynamic-Date-Comparison/m-p/304802#M495632 2012-01-25T10:47:57Z