topic Period comparison for selected MonthAndYear in QlikView https://community.qlik.com/t5/QlikView/Period-comparison-for-selected-MonthAndYear/m-p/384334#M143532 <HTML><HEAD></HEAD><BODY><P>Hey,</P><P></P><P>i have been browsing this community for ages but could not find a solution for my problem. Even though there is a lot of input on the topic nothing helped.</P><P></P><P>I would like to compare the Sales for a selected period of time (MonthAndYear) with the same period 12 month ago. My best result is this one:</P><P></P><P></P><P><STRONG>Sum({$&lt;CalendarYear={$(=max(CalendarYear)-1)}&gt;} Menge) </STRONG></P><P></P><P>With this scenario I have to select years and month in seperate Listboxes, thus selecting only 'Jan 2011' AND 'Dez 2010' is not possible (at least i dont know how)</P><P></P><P>I would like to have the solution based on my selection in the field CalendarMonthAndYear.</P><P></P><P>Could my Calender Format be the problem? Right now I use this one (Found it somewhere in the net) </P></BODY></HTML> Wed, 05 Sep 2012 10:12:22 GMT 2012-09-05T10:12:22Z Period comparison for selected MonthAndYear https://community.qlik.com/t5/QlikView/Period-comparison-for-selected-MonthAndYear/m-p/384334#M143532 <HTML><HEAD></HEAD><BODY><P>Hey,</P><P></P><P>i have been browsing this community for ages but could not find a solution for my problem. Even though there is a lot of input on the topic nothing helped.</P><P></P><P>I would like to compare the Sales for a selected period of time (MonthAndYear) with the same period 12 month ago. My best result is this one:</P><P></P><P></P><P><STRONG>Sum({$&lt;CalendarYear={$(=max(CalendarYear)-1)}&gt;} Menge) </STRONG></P><P></P><P>With this scenario I have to select years and month in seperate Listboxes, thus selecting only 'Jan 2011' AND 'Dez 2010' is not possible (at least i dont know how)</P><P></P><P>I would like to have the solution based on my selection in the field CalendarMonthAndYear.</P><P></P><P>Could my Calender Format be the problem? Right now I use this one (Found it somewhere in the net) </P></BODY></HTML> Wed, 05 Sep 2012 10:12:22 GMT https://community.qlik.com/t5/QlikView/Period-comparison-for-selected-MonthAndYear/m-p/384334#M143532 2012-09-05T10:12:22Z