Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Not applicable

sALES FOR PAST ONE YEAR

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 !!.

URGENT

1 Reply
er_mohit
Honored Contributor II

Re: sALES FOR PAST ONE YEAR

Try this

count({$< REGN_DATE = {">=$(=MonthStart(Max( REGN_DATE),-12))<=$(=MonthEnd(Max( REGN_DATE)))"},Year=,Month=>}REGISTERED_ID)