Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
AdminLoghaus
Contributor II
Contributor II

Clientes Ativos Acumulados 12 meses

Hello, I would like your help!

I am working with information on accumulated clients per month, without repeating them. In other words, within each month, I need to accumulate active clients in the last 12 months. I would like to do this in Set Analisys, but if you have another idea, I accept doing it in the script. Below is what I'm using:

RangeSum(
Above(
Aggr(
COUNT({<
TransactionType = {'Billing'},
SiteNumber = {'3500'},
SalesOrderType = P(FilterSalesOrderType),
SalesOrderType = {'Order','Exchange of Goods'},
SalesOrderItemUnitSalesValue = {">0"},
YearMonth = YearMonth
>} DISTINCT SalesOrderCustomerCode),
YearMonth
), 0, 12
)
)

0 Replies