topic sALES FOR PAST ONE YEAR in QlikView https://community.qlik.com/t5/QlikView/sALES-FOR-PAST-ONE-YEAR/m-p/405002#M150717 <HTML><HEAD></HEAD><BODY><P>hI i HAVE A COLUMN CALLED REGN_DATE , I EXTRACT MONTH,YEAR AND ALSO MONTHYEAR IN TWO DIFFERENT COLUMNS. i AM SHOWING A GRAPH OF NUMBER OF REGISTERATION PER MONTH. NOW IF I SELECT JAN2013 I SHOULD GET DATA FROM JAN2012 TO JAN2013 , HOW CAN I MODIFY MY =COUNT(REGISTERED_ID) FORMULA TO GET THAT DONE !!.</P><P></P><P>URGENT</P></BODY></HTML> Fri, 24 May 2013 12:07:26 GMT 2013-05-24T12:07:26Z sALES FOR PAST ONE YEAR https://community.qlik.com/t5/QlikView/sALES-FOR-PAST-ONE-YEAR/m-p/405002#M150717 <HTML><HEAD></HEAD><BODY><P>hI i HAVE A COLUMN CALLED REGN_DATE , I EXTRACT MONTH,YEAR AND ALSO MONTHYEAR IN TWO DIFFERENT COLUMNS. i AM SHOWING A GRAPH OF NUMBER OF REGISTERATION PER MONTH. NOW IF I SELECT JAN2013 I SHOULD GET DATA FROM JAN2012 TO JAN2013 , HOW CAN I MODIFY MY =COUNT(REGISTERED_ID) FORMULA TO GET THAT DONE !!.</P><P></P><P>URGENT</P></BODY></HTML> Fri, 24 May 2013 12:07:26 GMT https://community.qlik.com/t5/QlikView/sALES-FOR-PAST-ONE-YEAR/m-p/405002#M150717 2013-05-24T12:07:26Z Re: sALES FOR PAST ONE YEAR https://community.qlik.com/t5/QlikView/sALES-FOR-PAST-ONE-YEAR/m-p/405003#M150718 <HTML><HEAD></HEAD><BODY><P>Try this</P><P>count({$&lt;<SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;"> REGN_DATE</SPAN> = {"&gt;=$(=MonthStart(Max(<SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;"> REGN_DATE</SPAN>),-12))&lt;=$(=MonthEnd(Max(<SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;"> REGN_DATE</SPAN>)))"},Year=,Month=&gt;}<SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">REGISTERED_ID</SPAN>)</P></BODY></HTML> Fri, 24 May 2013 12:30:45 GMT https://community.qlik.com/t5/QlikView/sALES-FOR-PAST-ONE-YEAR/m-p/405003#M150718 er_mohit 2013-05-24T12:30:45Z