Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

set analysis with date

Hi,

I'm trying to implement a date range of last 12 month into the following formula.

can someone helps?

count({$<NUM_SUPPLIER.SUPPLIER_GROUP_CODE=, NUM_SUPPLIER.SUPPLIER_GROUP_DESC=, ZONE=>} distinct aggr(if(sum({$<NUM_SUPPLIER.SUPPLIER_GROUP_CODE=, NUM_SUPPLIER.SUPPLIER_GROUP_DESC=, ZONE=>}  NUM_SUPPLIER.Spend_Turnover)<>'0',NUM_SUPPLIER.SUPPLIER_CODE),NUM_SUPPLIER.SUPPLIER_CODE, RollingTwelveMonthsAsOfMonthYear))

Community Browser