topic Re: Previous year date in QlikView https://community.qlik.com/t5/QlikView/Previous-year-date/m-p/376880#M140492 <HTML><HEAD></HEAD><BODY><P>Its like previou year same date </P><P>i am using List boxes </P></BODY></HTML> Fri, 10 Aug 2012 12:03:50 GMT sivarajs 2012-08-10T12:03:50Z Previous year date https://community.qlik.com/t5/QlikView/Previous-year-date/m-p/376878#M140490 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a date field like below</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="WIDTH: 64px;"><TBODY><TR><TD height="17" width="64">Date</TD></TR><TR><TD align="right" class="xl63" height="17"><SPAN style="color: #ff0000;">5/28/2012</SPAN></TD></TR><TR><TD align="right" class="xl63" height="17">5/21/2012</TD></TR><TR><TD align="right" class="xl63" height="17"><SPAN style="color: #800000;">5/14/2011</SPAN></TD></TR></TBODY></TABLE><P>If i selects 5/28/2012 it should go to 5/28/2011 of previous year, if not it should give nearest value like 5/14/2011</P><P></P><P>How can i acheive this?</P><P></P><P>Regards</P><P>Sivaraj</P></BODY></HTML> Fri, 10 Aug 2012 11:04:31 GMT https://community.qlik.com/t5/QlikView/Previous-year-date/m-p/376878#M140490 sivarajs 2012-08-10T11:04:31Z Re: Previous year date https://community.qlik.com/t5/QlikView/Previous-year-date/m-p/376879#M140491 <HTML><HEAD></HEAD><BODY><P>what do you mean " If i selects 5/28/2012 it should go to 5/28/2011 " ??</P><P></P><P>can you be more specific?</P><P>what are your sheet objects?</P></BODY></HTML> Fri, 10 Aug 2012 11:56:43 GMT https://community.qlik.com/t5/QlikView/Previous-year-date/m-p/376879#M140491 2012-08-10T11:56:43Z Re: Previous year date https://community.qlik.com/t5/QlikView/Previous-year-date/m-p/376880#M140492 <HTML><HEAD></HEAD><BODY><P>Its like previou year same date </P><P>i am using List boxes </P></BODY></HTML> Fri, 10 Aug 2012 12:03:50 GMT https://community.qlik.com/t5/QlikView/Previous-year-date/m-p/376880#M140492 sivarajs 2012-08-10T12:03:50Z Re: Previous year date https://community.qlik.com/t5/QlikView/Previous-year-date/m-p/376881#M140493 <HTML><HEAD></HEAD><BODY><P>i konw that <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P>the goal is what objects you've got?</P><P></P><P>as i understand your post, you've got two listboxes with date</P><P>making selection in one of them couses changing selection in other right?</P><P></P><P></P><P>it will be better if you post a sample file, to show the objects you have</P></BODY></HTML> Fri, 10 Aug 2012 12:15:07 GMT https://community.qlik.com/t5/QlikView/Previous-year-date/m-p/376881#M140493 2012-08-10T12:15:07Z