Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need to create a measure with the sum of MedicalExpenses from the last 12 months just for the unsubscribed Members in the current month.
How can I accomplish that requirement?
Columns: MedicalExpenses , Members , UnsubscribedMembers
Thanks,
Facundo
need more details to help properly but you can use set analysis to achieve it.
something like below
Sum({<Type={'Unsubscribed'}, Date={">=$(=AddMonths(today(),-12))"}>}SalesAmount)
refer below for more on set analysis
https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344
Sum({<Type={'Unsubscribed'}, Date={">=$(=Monthstart(AddMonths(today(),-12)))"}>}SalesAmount)