https://community.qlik.com/t5/App-Development/Clientes-Ativos-Acumulados-12-meses/m-p/2509121#M104661 <P>Hello, I would like your help!</P> <P>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:</P> <P>RangeSum(<BR />Above(<BR />Aggr(<BR />COUNT({&lt; <BR />TransactionType = {'Billing'},<BR />SiteNumber = {'3500'},<BR />SalesOrderType = P(FilterSalesOrderType),<BR />SalesOrderType = {'Order','Exchange of Goods'},<BR />SalesOrderItemUnitSalesValue = {"&gt;0"},<BR />YearMonth = YearMonth<BR />&gt;} DISTINCT SalesOrderCustomerCode),<BR />YearMonth<BR />), 0, 12<BR />)<BR />)</P> Mon, 10 Mar 2025 19:32:03 GMT AdminLoghaus 2025-03-10T19:32:03Z https://community.qlik.com/t5/App-Development/Clientes-Ativos-Acumulados-12-meses/m-p/2509121#M104661 <P>Hello, I would like your help!</P> <P>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:</P> <P>RangeSum(<BR />Above(<BR />Aggr(<BR />COUNT({&lt; <BR />TransactionType = {'Billing'},<BR />SiteNumber = {'3500'},<BR />SalesOrderType = P(FilterSalesOrderType),<BR />SalesOrderType = {'Order','Exchange of Goods'},<BR />SalesOrderItemUnitSalesValue = {"&gt;0"},<BR />YearMonth = YearMonth<BR />&gt;} DISTINCT SalesOrderCustomerCode),<BR />YearMonth<BR />), 0, 12<BR />)<BR />)</P> Mon, 10 Mar 2025 19:32:03 GMT https://community.qlik.com/t5/App-Development/Clientes-Ativos-Acumulados-12-meses/m-p/2509121#M104661 AdminLoghaus 2025-03-10T19:32:03Z