topic how to get the same dates in previous year in QlikView https://community.qlik.com/t5/QlikView/how-to-get-the-same-dates-in-previous-year/m-p/706601#M476065 <HTML><HEAD></HEAD><BODY><P>Hi there,</P><P></P><P>Is there any way to get the same dates as selected by users in the previous year? I have tried addyear(orderdate,-1), but it only works out when there is one date to be selected. When the user select multiple dates, it does not work. Can anyone please help me out with this one? Thank you so much!</P><P></P><P>Best Regards,</P><P></P><P>Gloria</P></BODY></HTML> Wed, 18 Jun 2014 21:31:20 GMT 2014-06-18T21:31:20Z how to get the same dates in previous year https://community.qlik.com/t5/QlikView/how-to-get-the-same-dates-in-previous-year/m-p/706601#M476065 <HTML><HEAD></HEAD><BODY><P>Hi there,</P><P></P><P>Is there any way to get the same dates as selected by users in the previous year? I have tried addyear(orderdate,-1), but it only works out when there is one date to be selected. When the user select multiple dates, it does not work. Can anyone please help me out with this one? Thank you so much!</P><P></P><P>Best Regards,</P><P></P><P>Gloria</P></BODY></HTML> Wed, 18 Jun 2014 21:31:20 GMT https://community.qlik.com/t5/QlikView/how-to-get-the-same-dates-in-previous-year/m-p/706601#M476065 2014-06-18T21:31:20Z Re: how to get the same dates in previous year https://community.qlik.com/t5/QlikView/how-to-get-the-same-dates-in-previous-year/m-p/706602#M476066 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">concat( addyear(orderdate,-1), ', ')</SPAN></P></BODY></HTML> Wed, 18 Jun 2014 22:36:30 GMT https://community.qlik.com/t5/QlikView/how-to-get-the-same-dates-in-previous-year/m-p/706602#M476066 swuehl 2014-06-18T22:36:30Z