Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2011-08-01 11:52 PM

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))

230 Views
0 Likes
0 Replies