Add a sum range into a Count Set analysis

[PepeMontes]

Hello Dear Qlik community, hope everyon is doing well.

I have a question related to a set analysis that i already developed and its 100% functional:
(Count (Distinct { $ < Fecha=, Mes=, DiaAño=, Año=, MesAño={"$(=monthname(max(MesAño)-1))"}, [Desc. Razon Social]=-{"*MOSTRADOR*"}> } [Desc. Razon Social]))

This set analysis count the number of customers which had activity in the last month, this one its working fine, but i would like to add a new section into this set analysis,  something like the Sum of dollars amount between $20,000  and $30,000.

Anyone can asssit me with documentation related to this type of analysis?

Regards.

[vinieme12 · Accepted solution]

like below

Count ({ $ < Fecha=, Mes=, DiaAño=, Año=, MesAño={"$(=monthname(max(MesAño)-1))"}, [Desc. Razon Social]=-{"*MOSTRADOR*"}  ,  CustomerAccountNumber={"=sum(Amount)>20000 and sum(Amount)<30000"}  > }Distinct  [Desc. Razon Social])

Refer this article

https://community.qlik.com/t5/Qlik-Design-Blog/The-Expression-Search/ba-p/1463907