Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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