topic set analysis with date in QlikView https://community.qlik.com/t5/QlikView/set-analysis-with-date/m-p/323488#M498801 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I'm trying to implement a date range of last 12 month into the following formula.</P><P>can someone helps? <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>count({$&lt;NUM_SUPPLIER.SUPPLIER_GROUP_CODE=, NUM_SUPPLIER.SUPPLIER_GROUP_DESC=, ZONE=&gt;} distinct aggr(if(sum({$&lt;NUM_SUPPLIER.SUPPLIER_GROUP_CODE=, NUM_SUPPLIER.SUPPLIER_GROUP_DESC=, ZONE=&gt;}&nbsp; NUM_SUPPLIER.Spend_Turnover)&lt;&gt;'0',NUM_SUPPLIER.SUPPLIER_CODE),NUM_SUPPLIER.SUPPLIER_CODE, RollingTwelveMonthsAsOfMonthYear))</P></BODY></HTML> Tue, 02 Aug 2011 03:52:08 GMT 2011-08-02T03:52:08Z set analysis with date https://community.qlik.com/t5/QlikView/set-analysis-with-date/m-p/323488#M498801 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I'm trying to implement a date range of last 12 month into the following formula.</P><P>can someone helps? <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>count({$&lt;NUM_SUPPLIER.SUPPLIER_GROUP_CODE=, NUM_SUPPLIER.SUPPLIER_GROUP_DESC=, ZONE=&gt;} distinct aggr(if(sum({$&lt;NUM_SUPPLIER.SUPPLIER_GROUP_CODE=, NUM_SUPPLIER.SUPPLIER_GROUP_DESC=, ZONE=&gt;}&nbsp; NUM_SUPPLIER.Spend_Turnover)&lt;&gt;'0',NUM_SUPPLIER.SUPPLIER_CODE),NUM_SUPPLIER.SUPPLIER_CODE, RollingTwelveMonthsAsOfMonthYear))</P></BODY></HTML> Tue, 02 Aug 2011 03:52:08 GMT https://community.qlik.com/t5/QlikView/set-analysis-with-date/m-p/323488#M498801 2011-08-02T03:52:08Z